Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
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.
Greets,
Rega
Any suggestions?
Hi @Anonymous,
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.
Regards,
L.Meijdam
@AnonymousThanks for your suggestion. But i need to do with a Table not with a Matrix.
I hope somebody can help me.
Hi @Anonymous,
May I ask why you need to use a Table since a Matrix seems like the better choice if you want to display row subtotals.
Regards,
L.Meijdam
Hi @Anonymous
it's because i have a lot of columns values from a dimension that i will use.
@Anonymous wrote:Hi @Anonymous,
May I ask why you need to use a Table since a Matrix seems like the better choice if you want to display row subtotals.
Regards,
L.Meijdam
@Anonymous,
Check if the following measure works.
Measure = IF ( ISFILTERED ( Table1[Contributiegroep] ), DISTINCTCOUNT ( Table1[CUSTACCOUNT] ), SUMX ( ALL ( Table1[Contributiegroep], Table1[Contributietarief] ), CALCULATE ( DISTINCTCOUNT ( Table1[CUSTACCOUNT] ) ) ) )
hi @v-chuncz-msft,
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).
@Anonymous,
Please share us a simplified model and expected result.
@Anonymous,
Just post some dummy data and illustrate, but to be precise and concise.
hi @v-chuncz-msft,
here's the link to the pbi file.
Thank you so much!
https://1drv.ms/u/s!ApQVF85_XaxchkJedVai6AAm-IrL
@Anonymous,
To be honest, the example above is not simple or clear enough for us to understand.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |