Forum Discussion

DanielCarvalho's avatar
DanielCarvalho
Helper III
3 years ago
Solved

USERELATIONSHIP()

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 th...
  • puneetvijwani's avatar
    puneetvijwani
    3 years ago

    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?"

puneetvijwani's avatar
puneetvijwani
Resolver IV
3 years ago

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?"