Forum Discussion
Multiple Filters in Matrix with OR condition
I have a large Matrix and am trying to do multiple filters using OR instead of AND.
Step 1 - Filter Loss Ratio (Calculated Measure) if Store name (Provided Column) starts with "Z" then 75%, all else 85%.
Step 2 - Figure out how to add additional OR filters to the Loss Ratio Filter.
Filter Loss Ratio (Calculated Measure) if Store name (Provided Column) starts with "Z" then 75%, all else 85%. OR Loss Ratio Diff (Calculated Measure) is -10% OR Profit (Loss) (Calculated Measure) is -$10K. Whatever store has at least one of these things is all I want to see.
I made a simple Excel showing what I'm looking at VS what I'm hoping to get. Test.xlsx
Hi, Rlucero2
Step 1
Measure:
Loss Ratio Trigger = IF(LEFT(SELECTEDVALUE('Table'[Store Name ]),1)="Z",0.75,0.85)As for the second step, you need to explain what criteria are added to filter.
The two lines that disappear in your excel will not be displayed if they do not meet the conditions. You need to provide more details.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, Rlucero2
Step 1
Measure:
Loss Ratio Trigger = IF(LEFT(SELECTEDVALUE('Table'[Store Name ]),1)="Z",0.75,0.85)As for the second step, you need to explain what criteria are added to filter.
The two lines that disappear in your excel will not be displayed if they do not meet the conditions. You need to provide more details.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.