Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Select only blank

Hi,

I have a Disconnected Slicer which displays as this:

I have a measure to show only the selected certification, and if the certification is selected, it will show 1. My measure is right now is:

check =

var _sel = 'Disconnected Slicer (Certificate)'[SelectedChain]

var _chain = MAX('Staff Booking'[Certification])

RETURN

Switch(True(),


//containsstring(_chain,_sel),1,
SEARCH( _sel, _chain, 1,0 ) > 0, 1,
IF(ISBLANK(_sel), 1, 0) > 0, 1,
0)
 
How do i make it so that when I select the blank option in my disconnected slicer, only the empty rows will change the check column value to 1.
 
Right now, when i choose the blank option, even the rows will certificates will display as 1. My table currently looks like this:

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    Please have a try.

    Create a measure.

     

    check =

var _sel = selectedvalue('Disconnected Slicer (Certificate)'[SelectedChain])

var _chain = MAX('Staff Booking'[Certification])

RETURN

Switch(True(),


//containsstring(_chain,_sel),1,
SEARCH( _sel, _chain, 1,0 ) > 0, 1,
IF(_sel=blank(), 1, 0) > 0, 1,
0)

     

     

    If I hvae misunderstood your meaning, please provide pbix file (or some sample data ) without privacy information and desired output with more details.

     

    Best Regards

    Community Support Team _ Polly

     

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