Forum Discussion
1001
Resolver II
Resolver IICan Power BI Filter Multiple ranges in a data table
Hi, I have a data table with ID codes from 1 - 100,000. However, I have to filter three ranges within that table per the image below. Am I able to achive this through either DAX or the side bar filt...
Hi 1001 ,
Here are the steps you can follow：
1. Create measure.
Flag = SWITCH( TRUE(), MAX('Table'[Value]) >=79000&&MAX('Table'[Value])<=79999,1, MAX('Table'[Value]) >=89000&&MAX('Table'[Value])<=89999,1, MAX('Table'[Value]) >=90000&&MAX('Table'[Value])<=99999,1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi 1001 ,
Here are the steps you can follow：
1. Create measure.
Flag =
SWITCH(
TRUE(),
MAX('Table'[Value]) >=79000&&MAX('Table'[Value])<=79999,1,
MAX('Table'[Value]) >=89000&&MAX('Table'[Value])<=89999,1,
MAX('Table'[Value]) >=90000&&MAX('Table'[Value])<=99999,1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1001Thanks V, that's excxellent. I Appreciate that. Will apply it shortly. Cheers.