Forum Discussion

mtijnb's avatar
mtijnb
New Member
3 years ago
Solved

How to dynamically filter

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...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

     

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

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.