Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Maha1
Helper II
Helper II

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

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:

 

Capture.PNG

1 ACCEPTED SOLUTION

Hi @Maha1 ,

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

vjunyantmsft_0-1710730206384.png

You need to build another table for slicer:

vjunyantmsft_1-1710730230840.png

There is no relationship between tables:

vjunyantmsft_3-1710730289496.png

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:

vjunyantmsft_4-1710730368913.png

vjunyantmsft_5-1710730387528.png

The final output is as below:

vjunyantmsft_6-1710730414342.png
vjunyantmsft_7-1710730421058.png

vjunyantmsft_8-1710730428075.png


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.

View solution in original post

5 REPLIES 5
Wilson_
Memorable Member
Memorable Member

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?)

the same thing, all results with blank

Wilson_
Memorable Member
Memorable Member

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

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

Hi @Maha1 ,

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

vjunyantmsft_0-1710730206384.png

You need to build another table for slicer:

vjunyantmsft_1-1710730230840.png

There is no relationship between tables:

vjunyantmsft_3-1710730289496.png

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:

vjunyantmsft_4-1710730368913.png

vjunyantmsft_5-1710730387528.png

The final output is as below:

vjunyantmsft_6-1710730414342.png
vjunyantmsft_7-1710730421058.png

vjunyantmsft_8-1710730428075.png


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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.