Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm having trouble creating a measure that "join" two tables.
I would like to calculate the tickets that were not assigned by a technician.
For this, I have two tables:
tickets -> contains status (open, solved)
tickets_user -> informs who is associated with the ticket (requester or tech)
I would like to create a rule where:
Tell
1. ticket_status = 2 from ticket_table
2. ticket_assign_type <> 2 from ticket_user
In this way, I will know the open calls that were not associated with a technician.
can you help me?
Depending on other requirements, it could be something similar to this:
[# tickets] := CALCULATE( DISTINCTCOUNT( ticket_user[ticket_id] ), KEEPFILTERS( ticket_table[status] = 2), KEEPFILTERS( ticket_user[assign_type] <> 2 ) )
Of course, you have to have a relationship between the tables based on ticket_id. Your fact table is ticket_user (the many-side) and a dimension is ticket_table (the one-side). The field ticket_id in both tables should be hidden.
Best
Darek
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |