Forum Discussion
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.
Hi, I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
2 Replies
- Jihwan_KimSuper User
Hi, I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
- mitchlowesNew 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: RussiaFilter 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