Forum Discussion
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 filtering pane? Thanks.
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
4 Replies
- amitchandak
Super User
1001 , If can you want create bucket of on measure
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-kor static
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/ 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.
- Ashish_Mathur
Hi,
Share some data, describe the question and show the expected result.
