Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have data that is a log of tickets, timestamps, and usernames where a certain event has taken place. We want to see details of when the event has occurred more than once on a ticket. The raw data contains a row for each time the event occurred, including the ticket ID and timestamp. In this example I have a ticket that appears twice in the logs, since the event occurred twice.
I have what I will call a "reference" matrix to display the Ticket ID and Count of Ticket ID - this correctly identifies the ticket ID and a "2" in count, as expected.
However, I have "detail" matrix below it which I want to display all the rows of the selected Ticket in the log (2 instances), when the Ticket IDs in the reference is clicked. When clicking a ticket in the reference matrix, the detail matrix is only showing one row, despite there being two records for this one ticket.
Here is an example of my visuals:
Reference Matrix:
Ticket ID, Count of Event (2)
Detail Matrix:
Ticket ID, Timestamp (earliest), Other data
I want this result:
Reference Matrix:
Ticket ID, Count of Event (2)
Detail Matrix:
Ticket ID, Timestamp (earliest), Other data
Ticket ID, Timestamp (next earliest), Other data
Solved! Go to Solution.
@Anonymous Change the Detail Matrix to a table visual, then change the timestamp into 'Don't Summarize'
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@Anonymous Change the Detail Matrix to a table visual, then change the timestamp into 'Don't Summarize'
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com