Not showing row or column total

[jimpatel]

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

[Anonymous · Accepted solution]

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

[jimpatel]

Perfect

Thanks a lot for you help 🙂