Filter/slicer with 2 values on the same columns

Hi Anonymous 

To achieve this requirement:

Slicer should have 2 values - 1. fruit 2. All

if i select fruit - it will pull only fruits and if i selct All it should have fruit and remaining values as well.

Please follow steps below:

Based on my previous post, we have Table1 and Table2,

Besides all in my previous post,

create a new table without any relationship with other tables

Table3

Add [category_fruit] in the slicer

Create measures in Table1

isfiltered = ISFILTERED(Table3[category_fruit])

selected value = SELECTEDVALUE(Table3[category_fruit])

flag = IF([isfiltered]=TRUE(),IF([selected value]=MAX(Table2[category]),1,0),1)

Add [flag] in the visual level filter

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.