Forum Discussion

next-in-Line's avatar
next-in-Line
New Member
2 years ago

Power BI DAX

Hello, I have three slicers that I am using to filter data in my Power BI.

I would like that when any value of the three slicers is deselected my measure_output should return column e.

If none of the values in the slicers is deselected my measure_output should return column f.

Everything seems to be working as expected when a value is deselected in any of the three slicers.

However it does not work when no value is deselecetd in any of the three slicers, i.e. it is not possible to to return column f.

Here is my dax code any help on what I am doing wrong would be appreciated.

 

measure_output =
VAR measure_test =
        CALCULATE (IF(ISFILTERED('table'[b]) || ISFILTERED('table'[c]) || ISFILTERED('table'[d]), 'table'[e], DISTINCT('table'[f])))
RETURN measure_test

data protection

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    next-in-Line Well, it's a strange one. See my attached PBIX. First, I don't see the reason for the CALCULATE. But, more importantly it seems that not selecting anything in the slicers is different than selecting all of the items in each of the slicers unless you have the "Show 'Select All' option" toggled on under Slicer settings | Selection card.