Forum Discussion

Angads's avatar
Angads
Icon for Advocate I rankAdvocate I
3 years ago

Help with dax!

I want if select all is selected in date slicer it should show total sales for all dates, if no date selected it should show last date sales in date column and id any specific date selected it should...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Angads 
Please try

Values on selection =
IF (
    ISFILTERED ( Sheet1[Date] ),
    SUM ( Sheet1[Value] ),
    SUMX ( TOPN ( 1, Sheet1, Sheet1[Date] ), Sheet1[Value] )
)
Angads's avatar
Angads
Icon for Advocate I rankAdvocate I
3 years ago

Its giving same result as of my formula but not giving Total sales on selecting "select all".

other two conditions are met but not the select all one! tamerj1 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Angads 
    Are you using a custom visual slicer?

    Normal slicer seems to interact normally with the ISFILTERED funtion

    • Angads's avatar
      Angads
      Icon for Advocate I rankAdvocate I
      3 years ago

      No, Default slicer ! tamerj1 

    • Angads's avatar
      Angads
      Icon for Advocate I rankAdvocate I
      3 years ago

      What when Select all is also there in the slicer! That time its not working! tamerj1 

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

        Angads 
        You are right, "Select All" is different than selecting all items one by one but it behaves exactly the same as nothing is selected. It does not seem to be any way to distinguish between the two scenarios. 

        Greg_Deckler any ideas?