SUM IF in Power BI

Question

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?

score 11 · Accepted Answer · answered Jun 19 '18 at 15:04

11

Yes. There are two basic approaches to this.

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

or

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

answered Jun 19 '18 at 15:04

Alexis Olson

Perfect. First one works like a charm. I am sure the 2nd does too, but I didn't need to try it. – Shoaib Maroof Jun 19 '18 at 15:15

1 Answers1