show which filters have been selected using DAX

[Anonymous]

Hi Experts

I have the following filter in my report and i want to see which filter selections i have made/selected in a Card, my filter are Region, COunty and MAn Site

I can get one to work, how do i apply this principle to the other filters.

Filters Selected =
IF (
    ISFILTERED ( MyTable[MyColumn] ),
    CONCATENATEX ( FILTERS ( MyTable[MyColumn] ), MyTable[MyColumn], ", " ),
    "ALL"
)

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could set three measures like yours.

Or you can use "&" to show values together.

Measure =
IF (
    ISFILTERED ( SlicerA[Slicer A] ),
    CONCATENATEX ( FILTERS ( SlicerA[Slicer A] ), SlicerA[Slicer A], ", " ),
    "ALL"
) & "&"
    & IF (
        ISFILTERED ( SlicerB[SlicerB] ),
        CONCATENATEX ( FILTERS ( SlicerB[SlicerB] ), SlicerB[SlicerB], ", " ),
        "ALL"
    )