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,
I would like to have cumulative total sum of planned costs and currently I have used this formula:
Cumulative Planned = CALCULATE( SUM(Query1[Planned cost]); FILTER(ALL(Query1); Query1[Date]<=MAX(Query1[Date])))
.. and it worked until I needed to add another dimension 'reporting month' to the data. The idea of the reporting month is to keep track of changes of planned costs every month compared to previous month's data. So I would use reporting month in a slicer. But in this case the filtering is not correct for Cumulative Planned measure, as I have used ALL function in the formula.
Do you have any suggestions how to fix this?
Thank you in advance,
Liis
Solved! Go to Solution.
@Anonymous
I think you just need to replace ALL with ALLSELECTED
@Anonymous
I think you just need to replace ALL with ALLSELECTED
And as simple as that it was. Thanks 🙂
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |