Forum Discussion
Segmenter with multiple filtering options
Hello, capos good evening..
a crazy idea came to the head and I do not know if it is possible to take it .. what I want to do is that in the same segmenter it gives me several filtering options and that it can filter cluster 1 but without considering Geos, the same would happen if I filter Brazil and I want to consider Geos within its values.
This could be done with two segmenters one that filters the cluster first and then in the other territory segmenter remove Geos, but it is not a good way to do it since this is like it is very efficient for me.
More or less follow this theme. a single segmenter with multiple filtering options that says:
o Cluster 1 with Geos
o Cluster 1 with out Geos
o Cluster 2 with Geos
I have 3 tables like these that I have related by plant.
Cluster Territory Plant Value
| Cluster 1 | Andinar | Colombia | 25.00 |
| Cluster 1 | Andinar | Ecuador | 59.00 |
| Cluster 1 | Andinar | Peru | 76.00 |
| Cluster 1 | Mexico | Mexico | 60.00 |
| Cluster 1 | Andinar | Venezuela | 58.00 |
| Cluster 1 | PRICES | Nicaragua | 64.00 |
| Cluster 1 | PRICES | Guatemala | 51.00 |
| Cluster 1 | GEOS | Geos Colombia | 78.00 |
| Cluster 1 | GEOS | Geos Mexico | 2.00 |
| Cluster 2 | Brazil | Joinville | 49.00 |
| Cluster 2 | Brazil | Dos Santos | 54.00 |
I leave the table in case someone would like to help me 😞
Hi Syndicate_Admin ,
If you want to filter your table visual by one slicer with selection "Cluster 1 with Geos"/"Cluster 1 with out Geos" and so on, you can create a table with selection values you need then create a measure to filter your visual.
Filter = {"Cluster 1 with Geos","Cluster 1 without Geos","Cluster 2 with Geos","Cluster 2 without Geos"}Measure:
Measure = SWITCH( SELECTEDVALUE('Filter'[Value]), "Cluster 1 with Geos",IF(MAX('Table'[Cluster]) = "Cluster 1",1,0), "Cluster 1 without Geos",IF(MAX('Table'[Cluster]) = "Cluster 1"&&MAX('Table'[Territory])<>"GEOS",1,0), "Cluster 2 with Geos",IF(MAX('Table'[Cluster]) = "Cluster 2",1,0), "Cluster 2 without Geos",IF(MAX('Table'[Cluster]) = "Cluster 2"&&MAX('Table'[Territory])<>"GEOS",1,0), 1)Build a table visual , then add this measure in visual level filter field and set it to show items when value =1.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Syndicate_Admin ,
If you want to filter your table visual by one slicer with selection "Cluster 1 with Geos"/"Cluster 1 with out Geos" and so on, you can create a table with selection values you need then create a measure to filter your visual.
Filter = {"Cluster 1 with Geos","Cluster 1 without Geos","Cluster 2 with Geos","Cluster 2 without Geos"}Measure:
Measure = SWITCH( SELECTEDVALUE('Filter'[Value]), "Cluster 1 with Geos",IF(MAX('Table'[Cluster]) = "Cluster 1",1,0), "Cluster 1 without Geos",IF(MAX('Table'[Cluster]) = "Cluster 1"&&MAX('Table'[Territory])<>"GEOS",1,0), "Cluster 2 with Geos",IF(MAX('Table'[Cluster]) = "Cluster 2",1,0), "Cluster 2 without Geos",IF(MAX('Table'[Cluster]) = "Cluster 2"&&MAX('Table'[Territory])<>"GEOS",1,0), 1)Build a table visual , then add this measure in visual level filter field and set it to show items when value =1.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm going to test your answer, by that I confirm if I work on my model.
Thank you
Hi Syndicate_Admin ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.
Best Regards,Rico Zhou
