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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
fatimaarshd
Helper I
Helper I

How to access column in another table through bridged table?

This is what relationship looks like:

fatimaarshd_1-1697987348606.png

They had many to many relationship but then I created a bridge table Calendar. I need to get number of orders placed the next day. This dax just works fine. TotalPatients =
VAR NextDateInNotifications = MAX('Notifications'[Nudge Date]) + 1
RETURN
CALCULATE(
COUNTROWS(
SUMMARIZE(
FILTER(
ALLSELECTED('Orders'),
'Orders'[OrderCreationDatetime] = NextDateInNotifications
),
'Orders'[CustomerID]
)
)
)

 

The problem is that I need to count all customers who placed order in a specific category. Now, categories are mentioned in Notification table and not in orders table. I am confused about how to incorporate this? So for instance currently it gives me these counts.For instance if notification was received on 18, and order was placed on 19 then I will get count for 18 like this:

fatimaarshd_2-1697987667222.png

But now I need to add category in it as well. Please guide. 

 

5 REPLIES 5
andhiii079845
Solution Sage
Solution Sage

I think you have to share some sample data. Copy some data samples directly from excel in the textbox. Please so screenshot:)





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

Proud to be a Super User!




andhiii079845
Solution Sage
Solution Sage

Can you perhaps upload a better data example and what you want? 
You have bring both tables via the date togehter, so you only will be able to analyize every table for his one. 
You have not ID from the order table in the Notification table. 

 

 





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

Proud to be a Super User!




Yes, both of them have customer Ids. 

 

One idea: bring both table with a composite of the customerID-date together. You can than filter both tables with this combination? I think you have to invest more time in the data modelling topic. 

Perhaps you can merge both tables? 





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

Proud to be a Super User!




Merge isnt working as expected. I am merging both tables using full outer join and it only gives me matched rows and not mismatched rows

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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