Issue with showing Total in Matrix

[TimK]

I am sure i am doing something very basically wrong!!!

I have a PowerBI model (simplified) to show the issue - here

The issue i have is that i have a table with loads of P70 values (in Table 1)

I have written a measure to find the Max P70 for each line

The other table has values in it, and each value needs to be multiplied by the max P70 value......

I have written a measure to do it, which works, but i am not getting the totals at the bottom of the Matrix table - and i cannot work out why!!!!

Can anyone help please??

[TimK]

@amitchandak

Is it possible to show me in the PowerBI file here

[TimK]

sorry, but i am not that good with this, and the video does not help me!  😞

[amitchandak]

@TimK , if you row context, if or Time intelligenece, then you can issue with grand total,

Refer this https://www.youtube.com/watch?v=ufHOOLdi_jk