Forum Discussion

_-Christian-_'s avatar
_-Christian-_
Frequent Visitor
2 years ago

Interactive Highlighting with DAX Measure

Hello, 

 

i have a data set with tickets in a service process and want to build an operation dashboard. In this dashboard I want to show all open and closed tickets. In matrix A are the counts for created and closed tickets, with assigment group and month-year in the row header.

Close to the matrix A is a table B with all listed tickets. If the user click on created tickets for May2024 in Matrix A, then the table B is filtered by that. 

Clicking on created

Clicking on solved

All visuals excluded sensitive data. 

 

As you see, clicking on the number of solved tickets for May24 leads to the same filtering as created. 

 

I think my problem is, if I use a measure with a userelationship function, than table B will no filtered as expected. I only see the created tickets. 

 

Created Tickets =

     COUNT(tickets_metric[solved by Group])
 
Solved Tickets=
 CALCULATE(
     COUNT(tickets_metric[solved by Group]),
     USERELATIONSHIP(Calender[Date], incident_metric[solved by group created_on])
 )
 
Active Relationship in the Datamodel is created_date. Is it somehow possible to transfer the filter logic in a measure via clicking to another table?



Greetings
Christian 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi _-Christian-_ 

     

    It looks like you are using three tables and I can't create sample data to restore your scenario, could you please provide the sample data from the three tables you are using? That would be very helpful. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

     

    Best Regards,
    Yulia Xu