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 
Better to present a sample with the expected results as this new explanation does not match with the first one. If I follow your new explanation literally then just use SUM ( Sheet1[Value] )

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

I want total sales on card when i select "Select All" option in slicer.
or
if no date selected it should show last date sales in date column and id any specific date selected it should show sales for that dates. tamerj1 

  • 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