Wrong results. Data modelling problem.

[ROG]

Hi all,

All the tables below come from database and they're directquery.
I want to create some analysis between the tables Calendar and Subscriber, but it's not worrking.
As you can see below, they're not connected directly. What should I do? 

Thanks very much!

[PaulDBrown]

Is the inactive relationship between the Calendar date and the activation date? Are both fields set to type Date?

[ROG]

Hey @PaulDBrown  thanks for your reply. 
No relationship between Calendar and Subscribers table, and the Date and Activation Date are both set to date type.

[PaulDBrown · Accepted solution]

You need to create and inactive relationship between the Calendar date and the Subscribe activation date

Or if you prefey not to have the relationship. Try

Subrscibers =
CALCULATE (
    DISTINCTCOUNT ( Subribers[Cust ID] ),
    TREATAS ( VALUES(Calendar[Date]), Subscribers[Activation Date] )
)

[ROG]

Thanks a million @PaulDBrown 

It works and I was able to create similar measures using other fields. 

[PaulDBrown]

Create an inactive relationship between the Calendar Table and the Subscriber table via the corresponding date fields and use this measure:

ubrscibers =
CALCULATE (
    DISTINCTCOUNT ( Subribers[Cust ID] ),
    USERELATIONSHIP ( Calendar[Date], Subscribers[Activation Date] )
)

[ROG]

Thanks @PaulDBrown 

It's not working unfortunately. ☹️

Thank you