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

## Conditional Filtering

I'm trying to filter a page (or something I can apply to every viz).

The general structure of my two tables are:

 P Dollars Customer Prod GP Out abc Com 35 bac Dev 10 cba Serv 20 DD Com 7

 R Dollars Customer Prod GP In abc Com 5 bac Dev 35 cba Serv 0 DDD Com 15

I've combined the data into a matrix where I have made the following viz

 Viz Customer Prod GP In Out abc Com 5 35 bac Dev 35 10 cba Serv 0 20 DDD Com 15 7

The Filter I'm trying to apply to is:

1. if Prod GP = Serv, then show all rows where In OR Out are greater than or equal to 15

2. If Prod GP <> Serv, then show all rows where In OR Out are greater than or equal to 35

Applying this filter would keep 3 rows of data and remove the row for CUST DDD (the row that is in Bold/Italics/Underlined).

I've tried a couple if statements/calculates and gave filter a try, but I'm not familiar enough with them to get this to work.

Any help would be great appreciated,
Jason

1 ACCEPTED SOLUTION
Super User
``````Keep Row =
var selectedProdGP = SELECTEDVALUE('Table'[Prod GP])
var selectedIn = SELECTEDVALUE('Table'[In])
var selectedOut = SELECTEDVALUE('Table'[Out])
return INT(
(selectedProdGP = "Serv" && (selectedIn >= 15 || selectedOut >= 15)) ||
(selectedProdGP <> "Serv" && (selectedIn >= 35 || selectedOut >= 35))
)``````

The above is the measure that I came up with - you can place that measure in the filters pane and either keep those that are Keep Row = 1.

Super User
``````Keep Row =
var selectedProdGP = SELECTEDVALUE('Table'[Prod GP])
var selectedIn = SELECTEDVALUE('Table'[In])
var selectedOut = SELECTEDVALUE('Table'[Out])
return INT(
(selectedProdGP = "Serv" && (selectedIn >= 15 || selectedOut >= 15)) ||
(selectedProdGP <> "Serv" && (selectedIn >= 35 || selectedOut >= 35))
)``````

The above is the measure that I came up with - you can place that measure in the filters pane and either keep those that are Keep Row = 1.

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.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors