Forum Discussion
Need help adding a calendar table to my data model
I have already created the calendar table. The issue i am running into is being able to connect it to the 3 tables that i am using for the 3 measures that make up the Employee Productivity %
Community Championmmm ok sorry,
i checked the image just now,
your model is somehow complex
there is a lot of many to many with bidirectional filters which i assume is the reaon you cant connect the calendar table to all other tables.
i think you can create inactive relationship between the calendar and the 2 other tables .
and in the dax measure,
whenver you need to use that relationship,
write :
calculate ( aggregation , userelationship ( id 1 , id2 )
)
https://learn.microsoft.com/en-us/dax/userelationship-function-dax
https://dax.guide/userelationship/
or you can ignore creating inactive relationships and just propagate the filters using treatas function in DAX .
https://learn.microsoft.com/en-us/dax/treatas-function
https://dax.guide/treatas/
hope this helps .
best regards