Display in matrix based on selection from a filter

[NKotak_Leecare]

Hi all,

I have created three measures following this: Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI for displaying a message when nothing is selected from the filter and the visual remains empty. However, the filter that I have has values that are there in the visual as well. For example, the name by which I am filtering the visual is also present in the matrix visual itself. So, when I am adding the Hide Visual measure to the visual, it is ignoring it and displays all the name values even when nothing is selected from the filter. 

Measure 1: 

Check Filter = ISFILTERED(person[FullName]) -- Returns TRUE when any selection is made

Measure 2:

Hide Resident Visual BR =

IF(

    [Check Filter],

    1,

    0

)

Measure 3:

Message =

IF (

    [Check Filter],

    -- Check Filtered returns true or false based on selection in slicer

    "",

    --Give me nothing when Check Filtered returns True

    "You must first select a Resident from Resident Filter to see the results."

)

The filter and visual snapshots:

Do we have any solution for that?

Thank you!

[amitchandak · Accepted solution]

@NKotak_Leecare , Try to change measure like

Check Filter = calculate(ISFILTERED(person[FullName]), allselected())