topic Re: wrong column grand totals in DAX Commands and Tips

wrong column grand totals

DustinD — Fri, 11 Aug 2023 14:38:06 GMT

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.

Re: wrong column grand totals

Anonymous — Wed, 16 Aug 2023 02:13:37 GMT

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

Re: wrong column grand totals

DustinD — Wed, 16 Aug 2023 12:36:46 GMT

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

Re: wrong column grand totals

Anonymous — Thu, 17 Aug 2023 06:45:19 GMT

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