Forum Discussion
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/How-to-create-a-view-with-the-largest-three-values-for-each-row/m-p/1613533#M32464
Problem 1.
I have a table with more than 80 Attributes, like this:
I want to create a page with a simple view for each attribute, like this:
But, with an important difference. Each view must show only rows with the attribute value greater than a value chosen by the user (a threshold value). For instance, if the user choose the value 58%, the page should look like this:
So, each different attributes is filtered by the same value.
Things are even harder, because I need the threshold value to be a variable.
If it is the only viable solution, I can accept to put the threshold value in an Excel sheet given in input to Power BI (so I can change it) and refresh Power BI every time I need to change the threshold.
I would really appreciate any help.
Thank you
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
2 Replies
- amitchandak
Super User
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])))
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
