Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
This is what relationship looks like:
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:
But now I need to add category in it as well. Please guide.
I think you have to share some sample data. Copy some data samples directly from excel in the textbox. Please so screenshot:)
Proud to be a Super User!
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.
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?
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
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |