Forum Discussion
Anonymous
5 years agoNot applicable
Total Measure in Matriz Column
I'm trying to calculate commissions for a Sales Team. I'm almost there...the only thing that I don´t Know to do is "Totalize" the last column. It contains a measures for money...what I want to get it...
- 5 years ago
Hi Anonymous ,
Try this:
$_TOTAL = [$_Coverage] + [$_IP]$_TOTAL_2 = SUMX ( 'The table with the column under 'A.Flores'', [$_TOTAL] )If this doesn't work either, please share me your .pbix file for test. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Icey
5 years agoCommunity Support
Hi Anonymous ,
Try this:
$_TOTAL = [$_Coverage] + [$_IP]
$_TOTAL_2 = SUMX ( 'The table with the column under 'A.Flores'', [$_TOTAL] )
If this doesn't work either, please share me your .pbix file for test. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.