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...
Angads's avatar
Angads
Icon for Advocate I rankAdvocate I
3 years ago

Its giving me sales for selected date only. I am not getting answer for multiple dates select with above formuale also I want total sales when I select "select all" option in slicer. tamerj1 

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