Slicer filter matrix showing YTD on blank measure

[MennoHoogeveen]

I have a matrix showing a YTD measure. A single select slicer to select the date until which the matrix should so data. 
Now the user wants a TRUE/FALSE kind of slicer to be able to show only rows in which the current data has data (so NOT(ISBLANK([Measure])) ). I am able to do this directly on the matrix by adding a filter on field (measure) [Measure] with "is not blank". However, I have no idea how to accomplish this so the user is able to toggle it themselve.

 MatricesFields

Link to a .pbix example:

WeTransfer 

[Anonymous · Accepted solution]

Hi  @MennoHoogeveen ,

Here are the steps you can follow：

1. Enter Data – create a table.

2. Create measure.

Flag =
var _select=SELECTEDVALUE('Slicer_Tabel'[Flag])
return
IF(
    _select="Flase"&&[Measure]=BLANK(),0,1)Flag =
var _select=SELECTEDVALUE('Slicer_Tabel'[Flag])
return
IF(
    _select="Flase"&&[Measure]=BLANK(),0,1)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Select True:

Select Flase:

Best Regards,

Liu Yang

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

[MennoHoogeveen]

Worked perfectly, thank you!