Forum Discussion
Segmenter with multiple filtering options
- Anonymous4 years ago
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.
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 Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.