Problem with total

[Audrey_ADAPEI35]

Hello,

I've been trying for a while to resolve this measure. Can you help me?

I want to calculate a measure that estimate the average cost of a "place" for each month et a total of year.

	Janvier	Fevrier	Mars	Avril	Mai	Juin	JUillet	Août	Sept	Oct	TOTAL
Réel	254 897	293 704	335 793	277 280	264 968	324 731	220 378	220 085	311 416	249 253	2752 504 €
[81 - Agréments]	64	64	64	64	64	64	64	64	68	68	68
[266 - Coût net /agrément)	3983	4589	5247	4332	4140	5074	3443	3439	4580	3665	40 478 €
Agrément (ratio)	64	64	64	64	64	64	64	64	68	68	648
Coût net à la place total	3982	4589	5246	4332	4140	5073	3443	3438	4579	3665	4247 €

As for now, I show in my report the first 3 lines (in pink). For each month, it works fine but the total is incorrect as I wanted him to divide the total of "charges" by the maximum value of "agrément".

266- Cout net à la place = DIVIDE([1- Réel],[81-Agrément])

-> [1- Réel] is the sum of a column of my financial date

-> [81- Agrément] is the

VAR MaxDate = MAX('Agréments'[Date])

RETURN

CALCULATE(

    SUMX('Agréments','Agréments'[Agréments]),

    'Agréments'[Date] = MaxDate)

SO  I've been trying to have a measure that sum each month (lines in yellow) : it nows calculates an average (by month) instead of a total.

Coût net à la place total =

SUMX(

        VALUES(Comptes),

        DIVIDE([TEST1], [Agréement (ratio)])

    )

Where [Agréement (ratio)] is SUMX('Agréments','Agréments'[Agréments])

(for this one, ChatGPT helped me but the former ones diden't work either).

The expected answer is 42 492 €.

What am I missing?

Thank you very much for your answer !!!

[Audrey_ADAPEI35]

Thank you very much ! It works! 🙂 Have a great day !

[MFelix · Accepted solution]

Hi @Audrey_ADAPEI35 ,

Add a new measure with the following code:

Coût net à la place total Overall =
        SUMX(VALUES(Table[Month]),
         [Coût net à la place total]
    )

This will pick up the value of your last measure and just sum it across the months