Reply
Frequent Visitor
Posts: 3
Registered: ‎01-30-2018
Accepted Solution

Advanced Filters and Filtering

I have been successful in creating individual tables with the below criteria, but It has been requested by my boss to combine and only show the results when the criteria have been met.  Any suggestions?  

 

 

 

 

Any Time     
 Show Unit ID, MAT, and status when MAT below 48F
When OA is 83 and above    
 Show Unit ID, MAT, and status when MAT above 78F
When OA is above 70F and below 83  
 Show Unit ID, MAT, and status when MAT above 75F
When OA 50F or below   
 Show Unit ID, MAT, and status when MAT above 70F
When OA above 50F and below 70F  
 Show Unit ID, MAT, and status when MAT above 72F

Accepted Solutions
Established Member
Posts: 222
Registered: ‎07-13-2018

Re: Advanced Filters and Filtering

@benlynch i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.

 

you can write a swithc with following criteria

 

SWITCH(TRUE().

OA >= 83 && MAT < 48,"Y",

OA >= 70 && OA < 83 && MAT > 78,"Y",

"N")

 

Feel free to add the required conditions to create the filter and then filter results based on it.

View solution in original post


All Replies
Established Member
Posts: 222
Registered: ‎07-13-2018

Re: Advanced Filters and Filtering

@benlynch i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.

 

you can write a swithc with following criteria

 

SWITCH(TRUE().

OA >= 83 && MAT < 48,"Y",

OA >= 70 && OA < 83 && MAT > 78,"Y",

"N")

 

Feel free to add the required conditions to create the filter and then filter results based on it.

Highlighted
Community Support Team
Posts: 1,078
Registered: ‎07-10-2018

Re: Advanced Filters and Filtering

Hi @benlynch,

 

Could you please share you sample data here so that I can help with it?

 

Regards,

Frank

Frequent Visitor
Posts: 3
Registered: ‎01-30-2018

Re: Advanced Filters and Filtering

Ideally, I don't want to use bookmarks. 

 

PowerBi.PNGPowerBi1.PNG