Hello @TomMartens Thank you for the reply. I used that measure but something is not correct. Even if the Audit type key 2 = compliant instead of that giving me true other numbers are also giving me true. Am I missing something here?
I used the same measure. In the above scenario, for the employee Key 2, we see 2,3,4 as an audit type even if it has 2 this will be false because there is 3 and 4 in there for that employee key. if the audit type was 2 in all the lines then only we could say it is true or else we have to say false. I would really appreciate if you can help me with this Thank you once again.