Forum Discussion
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
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đź’ˇ
1 Reply
- Idrissshatila
Super User
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đź’ˇ