Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Solved! Go to Solution.
I'm assuming that the _Solved_in_Time column is a calculated column using an IF statement? If so, output the request_id in to this column rather than a 1. then you can perform a distinctcount measure on this column against the distinctcount measure on your initial request_id column
I'm assuming that the _Solved_in_Time column is a calculated column using an IF statement? If so, output the request_id in to this column rather than a 1. then you can perform a distinctcount measure on this column against the distinctcount measure on your initial request_id column
Thanks so much, works like a charm!
User | Count |
---|---|
88 | |
88 | |
73 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |