Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |