I need the sum of the values of a column that is a formula depending of the values of other columns

[NanardPet]

I need a measure to calculate the sum of "FCFF actualisé" (173.977,98 €) depending on the values of this table :

Année relative	FCFF	Coeff actualisation	FCFF actualisé
1	48.127,00 €	0,858471479	41.315,66 €
2	57.131,00 €	0,73697328	42.104,02 €
3	54.875,00 €	0,632670541	34.717,80 €
4	55.709,00 €	0,543129615	30.257,21 €
5	54.869,00 €	0,466261284	25.583,29 €
Total	271.711,00 €		173.977,98 €

Where Coeff actualisation = 1/(1+[WACC last agrégé])^SUMX([Année relative])

and FCFF actualisé = [FCFF]*[Coeff actualisation]

Could you help me ?

Thanking you in advance

Bernard

[Anonymous]

Hi @NanardPet ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) We can create a measure. 

sum of "FCFF actualisé = SUMX(SUMMARIZE('Table','Table'[Année relative],'Table'[FCFF actualisé]),'Table'[FCFF actualisé])

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[NanardPet]

Hi Neeko,

My problem is that 'Coeff actualisation' and 'FCFF actualisé' are two measures, and not present in the table:

Coeff actualisation = 1/(1+[WACC last agrégé])^SUMX([Année relative])

FCFF actualisé = [FCFF]*[Coeff actualisation]

So the SUMMARIZE formula doesn't recognize 'FCFF actualisé'

Any other idea to help me ?

Thanking you in advance

Bernard