wrong column grand totals

[DustinD]

i need some help trying to figure out why i cant get the right ammount for my column grand total. i have included a picture of the table and also my dax. i would like to get it where the end of rows give the total of evrething in the row.

[Anonymous]

Hi @DustinD,

I check the expression and find you add one category column in the Dax expression summarize function. When the expression calculate on the group total level, it should receive two direction of category filter effects(from row and column fields).

For this scenario, I'd like to suggest you add another category fields and try again.

If the above not help, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[DustinD]

@Anonymous could you give me an example of the dax you would use. thanks for all the help.

[Anonymous]

Hi @DustinD ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng