Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[SAHLER Marine]

SOLVED :

Hi Everyone, I’m new here… 

My problem is quite simple :
I would like a Sum of Max passengers on bord for a Class and a Date… It’s OK with the following formula, but it cannot calculate the sum for one flight !! It give me the MAX of the class it find… 

Formula :
NB_PAX = CALCULATE (MAX(Conso_CatSpec[Pax] ), DISTINCT(Conso_CatSpec[Flight]), DISTINCT(Conso_CatSpec[Dep.Date]))

See attached files for an exemple 

Many thanks for your help 🙂 
Marine

——————————
SAHLER Marine
——————————

[Olivier Aillery]

Hi,

You will need the SUMX function to compute every row of your data, so it should be something like :

Sum of MAX = SUMX( VALUES( [Class] ), CALCULATE( ALL( [Flights] ) , MAX ([Nb PAX]) ) )

Class = Eco, premium…
Flights = AF650YRGML
NB Pax your measure counting pax

Hope it helps

——————————
Olivier
——————————
——————————————-

[SAHLER Marine]

Hi Olivier,

And thanks for your response. 

I’ve tried your solution but it says “A function MAX has been used in a True/False expression that is used as a table filter expression. This is not allowed.”

If it can help, I attached an exemple of my table. 

Thanks again,
Marine

——————————
SAHLER Marine
——————————
——————————————-

[SAHLER Marine]

I found something : By mixing your solution with mine, it works !

Merci 🙂

NB_PAX_Class = SUMX( VALUES( Class[Class Géné]), CALCULATE (MAX(Conso_CatSpec[Pax] ), DISTINCT(Conso_CatSpec[Flight]), DISTINCT(Conso_CatSpec[Dep.Date])))

Many thanks,
Marine

——————————
SAHLER Marine
——————————
——————————————-

[Olivier Aillery]

De rien Marine et merci d’avoir partager la solution 🙂

——————————
Olivier
——————————
——————————————-