Date relationship ambiguity

[Anonymous]

Hello all

I've run into a bit of predicament with ambigous relationships. 

In my data model i have table with event data where events are pick ups, drop offs and the like, at various service points. The events have an event date that is linked to date table.

In another table i have a fact table containing information about the service points. The event table and service point fact table is linked via anoth table. The service point fact table contains a service point creation date. I would like to create a relationship between the service point creation date and the date table but can't because of the already existing link between the service point fact table and the date table via the event table.

The reason for me wanting the link is because I have a measure with the following formula : 

Utilization = CALCULATE(

COUNT('infinity piece_event'[event_id]),

FILTER('infinity piece_event','infinity piece_event'[event_type] = 103))

/

COUNT('infinity hardware_model_configuration'[compartment_id]) * (DATEDIFF(MIN('! Date'[Date]),MAX('! Date'[Date]),DAY)+1)

The measure calculates the amount of dropoffs and divides by that capacity in that time period.

My problem is, that if I want to look at a timeperiod that is not today service points that have not been created yet is a part of the capacity part of formula. I want to exclude the service points not created yet and I want to do it dynamically using a date slicer.

I hope my issue makes sense. 🙂

Relationships:

[v-diye-msft]

Hi @Anonymous 

you might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.