Forum Discussion

neonguyen's avatar
neonguyen
Frequent Visitor
7 years ago
Solved

How to sum total a measure

I have a report as bellow:   With measure "Final Commission" =  (([Total FEKid] * 300000) + ([Total FEJunior] * 200000) + ([Total FEOther] * 100000) + ([Total OldEnrollment] * 30000)) + [HN...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi neonguyen 

    Could you show me how you calculate the measure [HN-Commission Bonus], [Total FEKid]...?

     

    As tested, when i happen to this problem,

    assume my [Measure] refers to your measure "Final Commission" .

    i create other measures

    Measure 2 = SUMX(ALL(Sheet3[ec],Sheet3[rank]),[Measure])

Measure 3 = IF(HASONEVALUE(Sheet3[ec]),[Measure],[Measure 2])

     

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi neonguyen 

Could you show me how you calculate the measure [HN-Commission Bonus], [Total FEKid]...?

 

As tested, when i happen to this problem,

assume my [Measure] refers to your measure "Final Commission" .

i create other measures

Measure 2 = SUMX(ALL(Sheet3[ec],Sheet3[rank]),[Measure])

Measure 3 = IF(HASONEVALUE(Sheet3[ec]),[Measure],[Measure 2])

 

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.