Forum Discussion

PowerBIOrg's avatar
PowerBIOrg
Resolver 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. 

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PowerBIOrg ,

Please have a try.

Create a measure.

measure =
CALCULATE (
    SUM ( column[amtinsured] ),
    ALLEXCEPT ( column, column[industryfield], column[Rel] )
)

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

PowerBIOrg's avatar
PowerBIOrg
Resolver II
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.