Hi erveryone,
I have an issue with a Cumulated total measure, the measure is the following :
CALCULATE(
SUM('Sales'[Number of sales]),
FILTER(ALLSELECTED('Sales'[Date]) ,'Sales'[Date]<=MAX('Sales'[Date])
))
The measure is working as long i'm not trying to filter my datas, when i do ( For exemple when i'm filtering on all the sales > 0$, which is always the case ), the measure is not cumulating anymore and results in something like this :
Date | Numbers of sales |
01/03/2021 | 56 |
02/03/2021 | 54 |
03/03/2021 | 78 |
04/03/2021 | 80 |
05/03/2021 | 0 |
06/03/2021 | 65 |
Does anyone have an idea where the problem might come from ?
Thanks !
Solved! Go to Solution.
@QS7 , The date you are using should be the date from sales in visual
try like
CALCULATE(
SUM('Sales'[Number of sales]),
FILTER(ALLSELECTED('Sales') ,'Sales'[Date]<=MAX('Sales'[Date])
))
@QS7 , The date you are using should be the date from sales in visual
try like
CALCULATE(
SUM('Sales'[Number of sales]),
FILTER(ALLSELECTED('Sales') ,'Sales'[Date]<=MAX('Sales'[Date])
))
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!