USERELATIONSHIP()

[DanielCarvalho]

Hello guys, I have an issue with 3 of my tables where I am unable to make some of the relationships I need active. When I searched about this issue I see many people suggest creating measures with the userelationship() function. I tried to apply this to my own case but whenever I try I haven't managed to make it work. Could you give a suggestion of how I could fit this function into my measure? 

Created Cumulatitive = CALCULATE(COUNT('Distinct Tickets'[ActionDate]),filter(allselected('CALENDAR'),'CALENDAR'[DATE] <=max('Distinct Tickets'[ActionDate])))

In this case the distinct tickets table does not have a direct connection to the calendar table.

[puneetvijwani · Accepted solution]

@DanielCarvalho you probably need to create an inactive relationship between action date and your calendar date table and change the DAX to below 

Created Cumulative =
CALCULATE(
COUNT('Distinct Tickets'[ActionDate]),
USERELATIONSHIP('Distinct Tickets'[ActionDate], 'CALENDAR'[DATE]),
FILTER(
ALLSELECTED('CALENDAR'),
'CALENDAR'[DATE] <= MAX('Distinct Tickets'[ActionDate])
)
)

-------------------------------------------------------------------------------------------------------------------------------
"Good day, amigo! Have I provided the solution ? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?"