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 all,
Stuck on this issue - any help would be much appreciated
DateDim
Sales
I am trying to create a measure that is a cumulative total of the sales and is able to be filtered by the date table. I have the following measure which produces the cumalative sales
Cumalatve Sales =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER (
ALL ( DateDim[Date] ),
DateDim[Date] <= MAX ( DateDim[Date] )
)
)
However it not adjusting correctly for the date. As you can see from the graph, the first value is 1,246 which is a cumulative total of the previous three days. Instead it should start at 151 as the date filter is set to 5th March
Any help would be much appreciated.
Sample File -
Solved! Go to Solution.
Hi @Kurt4597 ,
You can modify Measure to the following form:
Measure =
CALCULATE(
SUM('Sales'[Sales]),
FILTER(ALLSELECTED(DateDim),
'DateDim'[Date]<=MAX('DateDim'[Date]))
)
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Kurt4597 ,
You can modify Measure to the following form:
Measure =
CALCULATE(
SUM('Sales'[Sales]),
FILTER(ALLSELECTED(DateDim),
'DateDim'[Date]<=MAX('DateDim'[Date]))
)
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |