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

[mitchlowes]

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.

[Jihwan_Kim · Accepted solution]

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

[mitchlowes]

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