Reputation: 3
I am having an issue creating a measure. I keep getting 100-0 instead of 100-75
Upvotes: 0
Views: 189
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