Forum Discussion
Calculation Headeach
I Have this type of data And I want to run a repport like this The first repport work fine, but when i collapse the society, the cumulative to do is not the cumulative I want (The c...
Hi,
Based on the description, try using the following measure formula and drag the measure to the matrix Values.
CumulativeToDo =
CALCULATE(
SUM('Table'[Global To Do]),
FILTER(
ALL('Table'[Month]),
'Table'[Month]<= MAX('Table'[Month])
)
)Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Wisdom Wu,
Many thanks to keep my problem in mind.
The solution you give to me couldn't be use, because I need a non cumulative to do, just the max to do for everyone, or when collapse the max for the Society, or for the Order.
Many thank for your help.