Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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" )
Solved! Go to 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" )
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" )
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |