Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    4 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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

I'm going to test your answer, by that I confirm if I work on my model.

Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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