Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Thanks
Chanikya A
@rveerasamy , better multiple them as columns
A new measure =
Sumx(Table, ([Amount]+[GST]+[CGST]+[SGCT]) *[TCS Rate])
@rveerasamy , No need to use Sum inside sumx all are columns
Sumx(Table, ([Amount]+[GST]+[CGST]+[SGCT]) *[TCS Rate])
Assuming all are columns
@rveerasamy , Where is ( ) on all amount columns? Please check I have done that in my shared measure.
else share you measure in text format. I can correct
| User | Count |
|---|---|
| 50 | |
| 41 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 72 | |
| 37 | |
| 27 | |
| 24 |