topic Re: Not showing row or column total in DAX Commands and Tips

Not showing row or column total

jimpatel — Wed, 24 Jan 2024 14:22:34 GMT

Hi,

Thanks a lot for looking at my post. Thanks a lot for below code from this forum.

I have below measure and it does not show the total value . What should I do get the totals populated please?

Measure 5 = if(Var a = CALCULATE(MAX('table (2)'[Date]),ALLEXCEPT('table (2)','table (2)'[Order number],'table (2)'[Operation Description])) return MAXX( FILTER('table (2)','table (2)'[Date]=a),'table (2)'[Date]),1,0)

thanks a lot

Re: Not showing row or column total

Anonymous — Thu, 25 Jan 2024 02:02:52 GMT

Hi jimpatel ,

If I understand correctly, the issue is that you couldn’t show the total value. Please try the following methods and check if they can solve your problem:

1.The use of IF without an aggregation function for the context is likely the cause of the issue.

2.Modify the formula and enter the following DAX formula.

Measure 5 = SUMX( VALUES('table (2)'[Order number]), VAR a = CALCULATE(MAX('table (2)'[Date]), ALLEXCEPT('table (2)', 'table (2)'[Order number], 'table (2)'[Operation Description])) RETURN IF( a = MAX('table (2)'[Date]), 1, 0 ) )

Alternatively, you can select the matrix visual. Navigate to the Format section and expand the totals option.

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format to make a deep troubleshooting? It would be helpful to find out the solution.

Looking forward to your reply.

Best Regards,

Wisdom Wu

Re: Not showing row or column total

jimpatel — Thu, 25 Jan 2024 10:53:13 GMT

Perfect

Thanks a lot for you help 🙂