Forum Discussion

ElvirBotic's avatar
ElvirBotic
Helper III
1 year ago
Solved

Change relationship based on graph selection

Hello,    I am wondering if there i s a proper way to handle multiple relationships when a user selects a bar graph value to filter a table based off of that new relationship. Currently I have a da...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello ElvirBotic 

     

    You can achieve this using USERELATIONSHIP in a measure instead of changing the active relationship.

     

    ActualClosures =
    CALCULATE(
    COUNT(FactTable[ID]),
    USERELATIONSHIP(DateDim[Date], FactTable[ActualDate])
    )

    Use this measure in your table visualization.

    When a user selects a bar from the Actual Closures graph, it will filter based on Actual Date.

    No need for separate pages

     

    Thanks,
    Pankaj

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

     

     

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello ElvirBotic 

 

You can achieve this using USERELATIONSHIP in a measure instead of changing the active relationship.

 

ActualClosures =
CALCULATE(
COUNT(FactTable[ID]),
USERELATIONSHIP(DateDim[Date], FactTable[ActualDate])
)

Use this measure in your table visualization.

When a user selects a bar from the Actual Closures graph, it will filter based on Actual Date.

No need for separate pages

 

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.