Forum Discussion

Rlucero2's avatar
Rlucero2
Frequent Visitor
4 years ago
Solved

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 e...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.