Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |