Forum Discussion
Measure through an inactive relationship
Hi there, im creating dashboard for a help desk system and have my relationships setup as below. For a given user I want to see how many tickets they have both raised and resolved in the same ...
I have found a way of doing it, I made a second relationship from 'AD Agent' to 'FW Tickets' via the different field and my measured worked like this
Raised Count = CALCULATE(DISTINCTCOUNT('FW Tickets'[ID]), USERELATIONSHIP('AD Agent'[userPrincipalName],'FW Tickets'[Requester Primary Email]))
Not sure if thats the best way of doing it but it will do unless anyone suggests anything better will stick with it!