Creating measure to show all values that I am filtered on.

[Anonymous]

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 for the column SKU/Material Desription. 

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

When I select two items to filter on, I only see the first non-blank value. I want to see all values I have filtered on. 

[Anonymous]

When multiple filters were selected the statement you gave resulted in the same value over and over again.

[PaulOlding · Accepted solution]

@Anonymous 

OK.  if you're not using a dimension table then you can use VALUES to get items listed once.

Selected = 
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], ", ") 
)

[PaulOlding]

Hi @Anonymous 

You could use CONCATENATEX to build a list of selected values

Selected = 
IF(
    ISFILTERED(TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description]), 
    CONCATENATEX(TRPT_FS_COPA_ADHOC_DTL_V2, TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description], ", ") 
)

[Anonymous]

A table would do, except I need the card or visual to be blank if no filters are selected. But I also need to be able to show all filters.

Card is blank with no filters selected.

With one filter selected is shows the filter. 

With more than one filter selected is shows this:

I need the visual to be blank if nothing is selected. But show every filter that is selected. 

[VahidDM]

Hi @Anonymous 

You can just add  TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description] to the table and then use filter pane rather than using codes. If I did not get your point correctly, Can you please add more details and make your question more clear.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/