Help on DAX statement

[Hash2023]

Hello Team,

I have the below table:

Client Code	PAX
1010	2
2020	3
1010	2
1010	2
3030	4

I need your help with a DAX formula to calculate the Total Pax but it has to take into account the unique client code.

From the table: My result should be 9 PAX (1010 = 2 + 2020 = 3 and 3030 = 4)

Thank you for your help.

Kind Regards,

Hash

[MFelix · Accepted solution]

Hi @Hash2023 ,

Try the following code:

Total PAX = SUMX(SUMMARIZE(Table, Table[Client], Table[CodePAX]), Table[CodePAX])

I'm assuming based on your sample that the CodePAX is always the same for the sames client.

[Hash2023]

Hi Miguel,

Thank you for your help. It works.

Kind Regards,