Forum Discussion

mitchlowes's avatar
mitchlowes
New Member
2 years ago
Solved

How to create a dynamic weighted average measure that changes depending on selected values

Hi.
I am really struggling with creating a weighted average percentage measure that I can use within my dashboard.

I have data like the below table:

What I want to achieve is to be able to create a weighted Relevance % column based on the Relevant total per Country-Date combination. This would look something like below (example first row: Total Relevant=74+1+1, Weight=74/76, Weighted Relevant/Total=0,973684*0,225609756): 

The problem I have is that I am not able to find a way to create a measure that takes on the value of the Weighted Relevant/Total.

Additionally, I would also want this Weighted Relevant/Total measure to be dynamic so that it changes if I filter out a certain Product Line for a specific Country-Date combination.

2 Replies

  • Hi, I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

    • mitchlowes's avatar
      mitchlowes
      New Member

      Thanks for this.
      This looks good.

      The only thing I am missing at the moment is that when I filter for product line the Weighted Relevant should also change.
      Example:
      Filter Country: Russia

      Filter Product Line: Prod2

      Filter Date: 11/8/2023

       

      Expected Weighted Relevant = 1 (because the Relevant Relevant becomes 1, rather than 72)

      Actual Weighted Relevant = 0,01389