Summing up a field with Max function

Hi @sikros

Since you have your measure doing a Max it is possible that the Sub Total is applying the Max as well at the sub-total level by default; see example below

But you can change the Totals property to use Sum instead and the results change accordingly.

I hope this is what is causing the problem. Can you try and let me know if that resolves your issue?

Regards,
Giri

1 Like