Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to create a measure that sums up the total response time of all the tickets. For example, the measure should generate 7 since ticket 1's response time is 3 days and ticket 2 is 4 days.
My measure gives 25 days but it should gives 7 days ( Calculate (Sum(table[Response Time]), ALLEXCEPT(Table, Table[Ticket ID])
Solved! Go to Solution.
Hi,
you can try
Hi,
You can create a new table by using following DAX code, Table3 is the table which contains two existing columns
what is RT?
RT is = min('Table'[Response Time]))
You obtain this
Hi,
you can try
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |