Grant total for Ratio column in matrix

[Anonymous]

Hi,

I have below 3 measures in my matrix view. The loss ratio column is nothing but Incurred losses over earned premium.

The % value is correct for the rows but the grant total(highlighted) is incorrect. In grand total, it just add all the values.

Please let me know if im missing something.

[dax]

Hi kthavamani, 

It seems to be a wrong total problem, in  your image your Earned Premium measure don't have grant total,  I think you need to calculate this total , then use measure like below

measure=IF (
    HASONEVALUE ( table[column]),
    [sum of loss ratio],
   [incurred losses]/[measure which have grand total]
)

If possible, you could upload your file or sample, then I will test this in my environment

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.