Forum Discussion

medonication's avatar
medonication
Helper I
5 years ago

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 ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

One way is to create Rank on Value weighted by VIO.2020 and Population and multiple then treat that as a score

  • medonication's avatar
    medonication
    Helper I
    5 years ago

    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...

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      medonication ,Can you share sample data and sample output in table format?

      • medonication's avatar
        medonication
        Helper I
        5 years ago

        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!!