CODEWITHSUNDEEP
powerbidaxpowerquery
Shoaib Maroof
Shoaib Maroof

Reputation: 369

SUM IF in Power BI

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?

Upvotes: 7

Views: 34065

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

Yes. There are two basic approaches to this.

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

or

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

Upvotes: 11

Related Questions