Forum Discussion

Capt_Flam's avatar
Capt_Flam
New Member
1 year ago

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...
"CALCULATE"
"MAX"
Capt_Flam's avatar
Capt_Flam
New Member
1 year ago

Hi Wisdom Wu,
Many thanks to keep my problem in mind, but the solution you give me, it's the solution I have and I need for ABC/A 130 for 2024-04, and for ADD/A 80 for 2024-04 and 2024-05 to calculate a good percentage for the avancement for ABC/A and ADD/A.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • Capt_Flam's avatar
    Capt_Flam
    New Member
    1 year ago

    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.