Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!