Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Kararo
New Member

DAX

I have a two tables (Student Program) & (Event Registration) both connected to third table (Contacts) as they don't have a direct connection.

 

How I can get the number of contacts that attended an event and registered for program.

 

 

5 REPLIES 5
Kararo
New Member

Yes!

What is your current DAX formula?

I am currently trying to use LOOKVALUE formula, but its not working, is there other formula to use?

Try using the RELATED() formula!

 

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

goncalogeraldes
Super User
Super User

Please provide a little bit more of context for your question or a sample file! Do you need to COUNT the number of students that registered and also attended? 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.