Manipulating Matrix table measures calculation

[Anonymous]

Hi PBI heroes

I am trying to get the below chart like how I did using excel sheets but I am stuck.

I already have the different calculated measures for "Gross sales" and "QTY" and "Number of customers" in my _Measure table but how can I place them all in this summary table based on the different rows and specific columns of the measure? And further use them to calculate the ASP by dividing Gross sales by Qty.

Many thanks in advance!

Regards

Shao

I have checked and researched on 

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

Refer to these two videos

https://youtu.be/PI52ckgezzA?si=wqOEXG2Cz0Z0v_qF

https://youtu.be/J4317R5BvsA?si=W5b1AIP5xnlJVKMt

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡