Distinct Count Grand Total by column dispaly wrong numbers

[AgoZ_KH]

Nice day to all!!

I came across the problem of totals in a column calculated with distinct count. I have a table with few columns.

WBS is a (univocal) code for a project; Uid is a univocal number for users; any WBS can have more than one user associated.

My scenario is like the figure here:

My problem is that the column total is 52 while the sum should be equal to 358 !! 

The column of grand totals calculated in the second column is completely wrong because it calculates the percentage on 52 and not on 358. 

I have tried some DAX formulas suggested in other Threads for summarize values of the distinct count column, but I always get the same result: the total sum is either the one in the column with Distinct count or the one summing the counts.

How can I solve my problem ??

Thanks in advance for help or suggestion!!

[v-danhe-msft]

Hi @AgoZ_KH,

From your description, it seemed a common issue about wrong total measure, you could refer to below link:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Regards,

Daniel He

[AgoZ_KH · Accepted solution]

Hi @v-danhe-msft, thanks for the suggestion.

I'd read this the post, but my problem seem to be slightly different. My problem was to summarize all the distict count values.

I tryed the proposed solution used here:

https://community.powerbi.com/t5/Desktop/DAX-Distinct-count-Total-in-table-to-be-sum-of-distinct-cou...

and it worked fine!!

Thanks to Community very very useful!

Regards

Ago