in the image below i have a Table with 4 columns that count distinct the values for each contributiongroup.
In the this table the Total dont sum the right amount.
I expect the following sum total :
141 and not 90
97 and not 61
141 and not 169
99 and not 68.
Thank you so much for help.
You have the option "row subtotals" enabled I assume ?
Anyway I went to test it myself results displayed below:
when I tried to do the same as you it diddnt work with this as a result
But when I added a column value it did work like below
Hope this points you in the right direction.
Check if the following measure works.
Measure = IF ( ISFILTERED ( Table1[Contributiegroep] ), DISTINCTCOUNT ( Table1[CUSTACCOUNT] ), SUMX ( ALL ( Table1[Contributiegroep], Table1[Contributietarief] ), CALCULATE ( DISTINCTCOUNT ( Table1[CUSTACCOUNT] ) ) ) )
Thanks for your suggestion.
Unfortunatly the result is still not what i would have expected.
I created, based on your measure, the measure X. In the following image you can see that the total sum of the measure x is 76.
When i export this table to Excel and calculate the sum of this row i get 99 (this is the right amount).
Please share us a simplified model and expected result.
Just post some dummy data and illustrate, but to be precise and concise.