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 cumulative for all the society regardless the month).

If you have ideas please don't hesitate to give me your feedback.

 

Kind regards

"CALCULATE"
"MAX"

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Capt_Flam ,

    Based on the testing, please drag the Global To Do to the Values.

     

    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, 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.