Forum Discussion

Angads's avatar
Angads
Advocate 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...
devanshi's avatar
devanshi
Helper V
3 years ago

 Totalsales = SUM([Sales])

VAR lastdatesvalues = CALCULATE(SUM([Sales]),LASTDATE(Date table))

VAR selected date = IF(ISFITHERED(Date table),

                                  IF(Date table)=BLANK(),lastdates),SUM([Sale]))

RETURN 

Totalsales