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

Hi Angads 
Please try

Values on selection =
SUMX ( TOPN ( 1, Sheet1, Sheet1[Date] ), Sheet1[Value] )
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] )
)