Forum Discussion
Measure Not adding up in Table Visual
Hi
I need to a Mgt Charge of 3,000 per sub-job into the below table.
Please snip of measure used and table below.
Issue is that the total of the mgt charge column in the table is 3,000.
It should be 3,000 x 258 sub-jobs = 774,000
Sean-OReilly , because you have taken a static value
New measure = 3000 * count(Table[sub-job])
or
New measure = 3000 * distinctcount(Table[sub-job])
3 Replies
Sean-OReilly , because you have taken a static value
New measure = 3000 * count(Table[sub-job])
or
New measure = 3000 * distinctcount(Table[sub-job])
Thanks amitchandak - distinctcount function was what i was missing
Sean-OReilly This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
