T_Whitfield
T_Whitfield

Reputation: 3

Power BI (Dax) Measure variance between same subcategory item, but different country

I am having an issue creating a measure. I keep getting 100-0 instead of 100-75

enter image description here

Upvotes: 0

Views: 189

Answers (1)

Himanshu Agrawal
Himanshu Agrawal

Reputation: 271

Try Changing the Dax for _Canada to below one for this case:

Var _Canada = Calculate([Cost], Filter(All(table_name), table_name[Country] = "Canada"), Filters(table_name[subcategory]), Filters(table_name[PartNumber]))

You will have to do the same for _US if you want to see the result WRT Canada as Country

Upvotes: 1

Related Questions