Forum Discussion

JLemaire's avatar
JLemaire
Frequent Visitor
2 years ago
Solved

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  
CustomerProd GPOut
abcCom35
bacDev10
cbaServ20
DDCom7

 

 

R Dollars  
CustomerProd GPIn
abcCom5
bacDev35
cbaServ0
DDDCom15

 

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

Viz   
CustomerProd GPInOut
abcCom535
bacDev3510
cbaServ020
DDDCom157

 

 

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 

Need Help
  • vicky_'s avatar
    vicky_
    2 years ago
    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.

1 Reply

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    2 years ago
    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.