Adding Grand Average next to Grand Total on Matrix

[Morran]

Hello everyone.

Currently, I'm dealing with an issue in which I want to add Grand Average of my 3 values next to the Grand Total. Please kindly find the image below. 
As you can see, I want to add the grand average of my stock, sales, and rate while keeping my Grand Total as it is. I've been searching for a feature of adding the average but nothing. Do you have any suggestions for me to tackle this challenge? Thank you.
Regards,

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but one of ways to achieve this is to have disconnected table and use a column from that table in a matrix visualization.

Please check the below picture and the attached pbix file.

[Morran]

Hi Jihwan, thanks for your response. It's a great DAX, but what if the stock, sales, and rate that I have is the measures not a data point? Do you have any idea what would be changed in the DAX you've just shared? Thank you.
Regards,
Morran

[Jihwan_Kim]

Hi,

Please share your sample pbix file.

Thanks.

[Morran]

Hi Jihwan, please kindly find my attached pbix through link below. https://drive.google.com/file/d/1SiwTSmyXIbSFG-ov28MNT55BWH8opLNe/view?usp=sharing 
Thanks, Jihwan

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your sharing.

Could you please check the attached pbix file whether it suits your requirement?

[Morran]

Thanks a lot Jihwan! This is exactly what I mean. 

Best regards,
Morran

[mangaus1111]

I mean something like this. It seems one matrix, but actually are 2

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

[Morran]

Ok, @mangaus1111 , 
Let me try and back to you

[Morran]

Hi @mangaus1111 , thanks for sharing your thought. 

Do you mean that I need to create 2 matrices as a layer?

[mangaus1111]

Hi @Morran ,

why don't you create 2 matrix, one with the sum, the other with the average, and you put one above the other?

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