Forum Discussion

PowerBIOrg's avatar
PowerBIOrg
Icon for Resolver II rankResolver II
2 years ago
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...
Need Help
  • PowerBIOrg's avatar
    PowerBIOrg
    2 years ago

    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.