Forum Discussion
Solved
Product Mix Ratio Calculation
Hi We have a sales table where we have all the sales of different product types. I can calculate % of total sales. What I want if the product types is 2 series, the % of total should be multiplie...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh2DVeeDMbnNzhfQo?e=Aq0chX
I created two variants for you
Ashish_Mathur
Super User
Super UserHi,
In the Query Editor or via a calculated column formula in the Data model, extract the number from the Product Types column in a seperate column. Rename this column as Number. Write this measure
Meausre 1 = sum(Data[Number]))
Measure 2 = SUMX(Values(Data[Product Types]),[% of total]*[Measure 1])
I am assuming that % of total is a measure that you have written.