Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Manipulating Matrix table measures calculation

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