Total does not add distinct customers

Question

Good day&nbsp;&nbsp;Currently I have brought in CustomerID and doing a distinct count ,but I am getting the incorrect total&nbsp;&nbsp;Campaign Name&nbsp; &nbsp; &nbsp;Distinct CustomerIDA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 90&nbsp;Is there any way I can get the total 100 which is a count of all the rows ?

aj1973 · Accepted Answer

It looks like you have a similar issue like this:https://community.powerbi.com/t5/Desktop/visual-total-not-matching-sum-of-individual-row/m-p/1183586#M532054&nbsp;&nbsp;

Forum Discussion

Total does not add distinct customers

2 Replies

Related content

custom total row

distinct total

count distinct

Total Customers (end of month)

DAX Distinct count. Total in table to be sum of distinct counts per row, not total distinct