Total SUM on Row level in Table not working

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

@AnonymousThanks for your suggestion. But i need to do with a Table not with a Matrix.

I hope somebody can help me.

[Anonymous]

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]

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

---

[v-chuncz-msft]

@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] ) )
    )
)

[Anonymous]

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).

[v-chuncz-msft]

@Anonymous,

Please share us a simplified model and expected result.

[Anonymous]

@v-chuncz-msftHow can i share my pbix to you?

[v-chuncz-msft]

@Anonymous,

Just post some dummy data and illustrate, but to be precise and concise.

[Anonymous]

hi @v-chuncz-msft,

here's the link to the pbi file.

Thank you so much!

https://1drv.ms/u/s!ApQVF85_XaxchkJedVai6AAm-IrL

[v-chuncz-msft]

@Anonymous,

To be honest, the example above is not simple or clear enough for us to understand.