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 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?

 

 

 

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.

     

3 Replies

  • 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.

     

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    mtijnb , Assume you have two measures score and weighted score

     

    Then

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

    return

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