You can't create a direct active relationship between Tb1 and Tb2 because that would introduce...

[gemini56]

I want to create a funnel analysis in Power BI, tracking the journey from user registration to app navigation while filtering by date. However, I need help to establish a direct relationship between the user's table and the calendar table. This limitation is due to "You can't create a direct active relationship between users and calendar because that would introduce ambiguity between tables calendar and app_navigation."  How can I address this issue and proceed with my desired analysis? 

[AliceW]

It makes sense PBI stops the creation of this relationship. Why can't you use the 'DateRegistered' from the Users table?

If you have great columns/parameters built in the Calendar table, you might want to consider duplicating it, and having the duplicate one connected to the Users.

[gemini56]

I'm using the "Date" column from the "Calendar" table as a date filter in my funnel. However, there's no direct relationship between the "Users" and "Calendar" tables, so when I apply the date filter, the number of users created doesn't change.

[AliceW]

Ok, what do you want to see in your report? The date the User was created? Or the date the app navigation took place?

[gemini56]

I want to select both because I want to specify a particular time frame, such as from October 1st to October 20th, and determine how many users were created during that period and how many used the app. Please forgive my questions; I'm quite new to Power BI, and I appreciate your guidance.

[AliceW · Accepted solution]

Well, in that case, create a connection between User and Calendar, but make it inactive.

Then, create a measure like this:

Created Users in Period =

calculate(

distinctcount(Users[UserID]),

userelationship(Users[DateRegistered], Calendar[Date]).

And for the users using the app:

Users Using in Period =

distinctcount((App Navigation[UserID])

[gemini56]

It works. You rock. Thank you so much ^^

[AliceW]

Happy to hear it solved your problem! You're welcome!

[Brunner_BI]

If you use a column from the calendar table in a visual you should be able to do your analysis now already.

Alternatively, you could turn on bi-directional filtering between app navigation and calendar which creates other problems but might help you initially.

[gemini56]

The issue is that it's not working as the "Date Registered" in the "Users" table has no connection to the "Date" in the "Calendar" table. Consequently, the count of registrations isn't being filtered by the selected date.