Forum Discussion

Sixian's avatar
Sixian
Frequent Visitor
5 years ago
Solved

How to filter a page with different attributes using the same value

I'm struggling with a couple of problems in the same project and I'll post two different help request. You can find the Problem 2 in this post: https://community.powerbi.com/t5/DAX-Commands-and-Tips...
  • Sixian's avatar
    Sixian
    5 years ago

    At the end, I worked around your suggestion to use Whatif[value].

    I need to create a measure for each Attribute (Sigh!!!), like this:

    filter Measure Attribute 01= IF(SELECTEDVALUE('Table'[Attribute 01)]) >= 'Whatif'[value], "Yes", "NO")
    Then, I have to apply the "filter Measure Attribute 01" to the Attribute 01 view.
     
    Thank you
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Sixian , assuming Whatif[value] is your slicer. You need to have these three measures in you tables

assumes Attribute1 , Attribute2, Attribute3 are measures, or use Sum/Average or those

 

calculate([Attribute1], filter(Values(Table[Name]), [Attribute1] >=selectedValue(Whatif[value])))

 

calculate([Attribute2], filter(Values(Table[Name]), [Attribute2] >=selectedValue(Whatif[value])))

 

calculate([Attribute3], filter(Values(Table[Name]), [Attribute3] >=selectedValue(Whatif[value])))

Sixian's avatar
Sixian
Frequent Visitor
5 years ago

At the end, I worked around your suggestion to use Whatif[value].

I need to create a measure for each Attribute (Sigh!!!), like this:

filter Measure Attribute 01= IF(SELECTEDVALUE('Table'[Attribute 01)]) >= 'Whatif'[value], "Yes", "NO")
Then, I have to apply the "filter Measure Attribute 01" to the Attribute 01 view.
 
Thank you