How to dynamically filter

[mtijnb]

Hi,

I need a bit of help with a simple question: I have the following table where I calculate the weighted score of a country (weight x score). In my dashboard I have a KPI, that shows the average score. On this KPI I have a filter of all the countries - when all countries are selected the average of the weighted score should be shown, however when you select one country, it needs to display only the score of that country, instead of the weighted score. Is there a simple way to built this?

[v-zhangti · Accepted solution]

Hi, @mtijnb 

You can try the following methods.

Measure = 
IF ( SELECTEDVALUE ( 'Table'[Country] ) <> BLANK (),
     SELECTEDVALUE ( 'Table'[score] ),
     AVERAGE ( 'Table'[Weighted score] )
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mtijnb]

Would you be able to create an example file?

[amitchandak]

@mtijnb , Assume you have two measures score and weighted score

Then

var _hasone = calculate(hasonevalue(Table[Region]), allselected())

return

if(_hasone, [Score],[weighted score])