Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |