SUM IF in Power BI

powerbi dax powerquery
Shoaib Maroof picture Shoaib Maroof · Jun 19, 2018 · Viewed 20.3k times · Source

Is it possible to SUM on conditions in Power BI?

I have a column that contains the values UK and Italy alongside other columns: employee and hours spent.

I want to make a measure to show total hours spent by an employee in Italy and another to show total hours spent by an employee in UK.

I am having no luck with the DAX language. Can anyone help?

Answer

Alexis Olson picture Alexis Olson · Jun 19, 2018

Yes. There are two basic approaches to this.

CALCULATE(SUM(TableName[Hours]), TableName[Country] = "Italy")

or

SUMX(FILTER(TableName, TableName[Country] = "Italy"), TableName[Hours])

Related questions

What's the difference between DAX and Power Query (or M)?

I have been working on Power BI for a while now and I often get confused when I browse through help topics of it. They often refer to the functions and formulas being used as DAX functions or Power Query, …

Read More
how to convert a Integer to Text value in Power BI

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I tried below query which give syntax error to me, = Number.ToText(table1.[RegionID]) & " " & table1.[RegionName] I tried some …

Read More
How to format new measure (not column) in power BI as percentage?

When I create a new measure with formula, i.e. sum(col1)/max(col2), it automatically converts the result into #.#% format. Strangely, it doesn't happen all the time; sometimes it just gives result #.## format. Any idea of how to format …

Read More