How to sum total a measure

[neonguyen]

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.

[v-juanli-msft · Accepted solution]

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.