Forum Discussion
Weighted Average Score
Dear PBI Community, I need your help to achieve a task that took me too much time (which sound so complex but in reality it isn't) I want to calculate the average score of a brand and show it ...
Thank you very much Amitchandak for your answer. The score is a percentage and if a user filter one country, one vehicle type and one product I want to show the actual row value.
I think the only difficulty here is to calculate the overall Population which divide the weighted score. To be concret this sumx in my code "SUMX('Structure','Structure'[Population])" needs some changes...
medonication ,Can you share sample data and sample output in table format?
this is a sample of the table i filtered two brands, two countries and one attribute which should be a legend.
Last column is the population which is our weight and value is the score as you see in percent.Thanks for your efforts!!
amitchandak can you see the screenshot ?