Forum Discussion

dpiechowski's avatar
dpiechowski
Icon for Helper I rankHelper I
6 years ago
Solved

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

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

 

Tutorial Requests
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

4 Replies