Power BI Exchange

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

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

Original Message:
Sent: May 11, 2022 10:10 AM
From: SAHLER Marine
Subject: Sum of MAX

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

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

Original Message:
Sent: May 12, 2022 03:23 AM
From: Olivier Aillery
Subject: Sum of MAX

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

Original Message:
Sent: May 11, 2022 10:10 AM
From: SAHLER Marine
Subject: Sum of MAX

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

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

Merci :)



------------------------------
SAHLER Marine
------------------------------

Original Message:
Sent: May 12, 2022 08:34 AM
From: SAHLER Marine
Subject: Sum of MAX

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

Original Message:
Sent: May 12, 2022 03:23 AM
From: Olivier Aillery
Subject: Sum of MAX

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

Original Message:
Sent: May 11, 2022 10:10 AM
From: SAHLER Marine
Subject: Sum of MAX

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

De rien Marine et merci d'avoir partager la solution :-)

------------------------------
Olivier
------------------------------

Original Message:
Sent: May 12, 2022 10:48 AM
From: SAHLER Marine
Subject: Sum of MAX

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

Original Message:
Sent: May 12, 2022 08:34 AM
From: SAHLER Marine
Subject: Sum of MAX

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

Original Message:
Sent: May 12, 2022 03:23 AM
From: Olivier Aillery
Subject: Sum of MAX

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

Original Message:
Sent: May 11, 2022 10:10 AM
From: SAHLER Marine
Subject: Sum of MAX

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