How can I get blank values if no filter was applied?

[Maha1]

I want my table to show blank if no selection was applied. I tried ISFILTERED and HASONEVALUE but they all keep giving the same results:

[Wilson_]

Hi Maha1,

Try BLANK() instead of 0.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

[Maha1]

the same thing, all results with blank

[Wilson_]

I'm confused, I thought you said you wanted blanks.

[Maha1]

I want the whole table to be empty if no selection was applied

[Anonymous · Accepted solution]

Hi @Maha1 ,

I can give you an example, here is my sample data:

You need to build another table for slicer:

There is no relationship between tables:

Use this DAX to create a measure:

Measure = 
IF(
    ISFILTERED(Slicer[Slicer]),
    IF(
        MAX('Table'[ID]) IN VALUES(Slicer[Slicer]),
        1,
        0
    ),
    0
)

Please follow the screenshot below to set up:

The final output is as below:

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