Using a measure to hide a table until filtered, not working?

[dpiechowski]

I'm trying to get that table to not show anything until it is being filtered by either the DESCR slicer or the Map being clicked on, because otherwise it's 11k+ entries. I feel like I must be missing something...

m.Hide? = IF(ISFILTERED(INVENTORY_BIN[DESCR]),1,IF(ISFILTERED(BIN_LIST[Zone/Tower]),1,0))

[v-lili6-msft · Accepted solution]

hi  @dpiechowski 

You could just adjust the formula as below:

m.Hide? =
IF (
    CALCULATE ( ISFILTERED ( INVENTORY_BIN[DESCR] ), ALLSELECTED ( INVENTORY_BIN ) ),
    1,
    IF (
        CALCULATE ( ISFILTERED ( BIN_LIST[Zone/Tower] ), ALLSELECTED ( BIN_LIST ) ),
        1,
        0
    )
)

Then it will work.

Regards,

Lin

[dpiechowski]

This works beautifully. Thanks

[amitchandak]

@dpiechowski , see if you can use it using the bookmark

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[dpiechowski]

I think I figured it out.

It seems like if the ISFILTERED measure is checking any of the columns that are in the table it doesn't work.