Forum Discussion
Solved
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 sho...
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 , 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