Forum Discussion

RJ_KON's avatar
RJ_KON
Icon for Helper I rankHelper I
4 years ago
Solved

DAX measure using isfiltered function

Hi-Power BI geeks,   I am trying to bring text display into the card visual and it should display when two slicers and one clustered bar chart visuals are filtered. So I tried to use the below Dax...
Tips and Tricks
  • RJ_KON's avatar
    RJ_KON
    4 years ago

    Thanks, Paul, it worked:)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I am in a similar boat, I am using the code. Current Sku/Description =
IF (
    ISFILTERED ( TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description] ),
    FIRSTNONBLANK (
        TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description],
        TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description]
    ),
    ""
)

 

This creates a measure that shows on a card only the selected filter. 

But what I need help with is having the card show multiple filter selections. Instead of just the first non-blank filter selection. 

 

 

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Is the value displayed that if the selected value in the filter? If so, so can try something along the lines of:

    Filter Values =
IF (
    ISFILTERED ( TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description] ),
    CONCATENATEX (
        VALUES ( TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description] ),
        TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description],
        ", "
    ),
    ""
)