Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cumulative not working correctly

https://drive.google.com/file/d/1pWvFXrZcE9s8QAq9dBjkaBSEUlJMJCRD/view?usp=sharing         I am trying to get the cumulative of EW , and it is not working. Why is this happening ,I unders...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , have you tried measures like these with or without help from date table

 

example

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))

 

also you can try quick measure

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Of course  i tried this 

Cumulative EW =
CALCULATE([EW], FILTER (
ALLSELECTED ( 'Date' ),
'Date'[Date] <= MAX ( 'Date'[Date] ) ))
 
But not working.
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak Could you please help?