Forum Discussion

DavidUK0's avatar
DavidUK0
Frequent Visitor
3 years ago

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 visual, the active relationship from "AD Agent" to "FW Tickets" is on email address, but there is a second inactive relationship from "AD Agent" to "AD Raised By" which in turn has an active relationship to "Requester Primary Email" on "FW Tickets"

 

My ticket count measure is as below

Ticket Count = DISTINCTCOUNT('FW Tickets'[ID])
Trying to get the ticket count via that inactive relationship I have tried these two but the number remains the same
Raised Count = CALCULATE(DISTINCTCOUNT('FW Tickets'[ID]), USERELATIONSHIP('AD Raised By'[userPrincipalName], 'FW Tickets'[Requester Primary Email]))
 
Raised Count = CALCULATE(DISTINCTCOUNT('FW Tickets'[ID]), USERELATIONSHIP('AD Agent'[ExternalObjectID],'AD Raised By'[ExternalObjectID]))
 
Any advice?
Thanks
Need Help

1 Reply

  • DavidUK0's avatar
    DavidUK0
    Frequent Visitor
    3 years ago

    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!