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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
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.