cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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-v...

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

1 ACCEPTED SOLUTION
Frequent Visitor

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 2
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])))

Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.