Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Reply
Hash2023
Frequent Visitor

Help on DAX statement

‎10-09-2023 11:44 PM

Hello Team,

 

I have the below table:

Client CodePAX
10102
20203
10102
10102
30304

 

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

Message 1 of 3
409 Views
0
1 ACCEPTED SOLUTION
MFelix
Super User
Super User

‎10-11-2023 12:55 AM

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português





View solution in original post

Message 2 of 3
405 Views
2 REPLIES 2
MFelix
Super User
Super User

‎10-11-2023 12:55 AM

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português





Message 2 of 3
406 Views
Hash2023
Frequent Visitor
In response to MFelix

‎10-17-2023 02:23 AM

Hi Miguel,

 

Thank you for your help. It works.

 

Kind Regards,

Message 3 of 3
381 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

View All