Measure Not adding up in Table Visual

[Sean-OReilly]

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

[Greg_Deckler]

@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

[amitchandak · Accepted solution]

@Sean-OReilly , because you have taken a static value

New measure = 3000 * count(Table[sub-job])

or

New measure = 3000 * distinctcount(Table[sub-job])

[Sean-OReilly]

Thanks @amitchandak - distinctcount function was what i was missing