topic Re: Calculation Headeach in DAX Commands and Tips

Calculation Headeach

Capt_Flam — Mon, 07 Oct 2024 15:41:53 GMT

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

Re: Calculation Headeach

Anonymous — Tue, 08 Oct 2024 07:23:10 GMT

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.

Re: Calculation Headeach

Capt_Flam — Tue, 08 Oct 2024 08:26:10 GMT

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.

Re: Calculation Headeach

Anonymous — Wed, 09 Oct 2024 09:08:19 GMT

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.

Re: Calculation Headeach

Capt_Flam — Mon, 14 Oct 2024 07:30:13 GMT

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.