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-Commission Bonus]
 
Every thing look like good, but with total ( red frame), it is not sum of column value. I'm looking how to sum this column.
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.

1 Reply

  • 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.