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.