Hash2023Frequent Visitor2 years agoSolvedHelp on DAX statement 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...Show MoreMFelix2 years agoHi 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.
MFelix2 years agoHi 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.
MFelix2 years agoHi 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.
MFelixSuper User2 years agoHi 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.
Hash2023Frequent Visitor to MFelix2 years agoHi Miguel, Thank you for your help. It works. Kind Regards,
Related contentCASE Statement to DAXMultiple IF statements in DAXDAX If Vlookup StatementsLearning to write DAX statementsDAX If Statement
