Forum Discussion
Solved
Overall Total in same category return different values
Dear experts, I want to get the overall total of Industry for each Corporate. When I check on certain Industry Field, it returns different values even under same industry. I expect the Overall In...
Hi,
I found that those fields in AllExcept() need to be unique if want to pick more than 1 value in order to get the Overall Total for each category (IndustryField).
I create a unique value table for "TypeofClaims" field where
T_TypeofClaims = VALUES('Column'[TypeofClaims])
And change my measure as following then it works.
PowerBIOrg
Your question isn't clear, please share the expected result based on your current selection.