Create calculated Table with conditions

[Nepal101]

Hello Everyone, 
I am trying to create a calculated table with a given logic shown in the pic below 

I basically need two lines of true and false in a new table saying if there is any missing or expired then it should be false or else true for the given date and driver. 

I would appreciate it if you can help me with this 
Thank you in advance. 

[TomMartens · Accepted solution]

Hey @Nepal101 ,

from my understanding this measure will return what you are looking for:

Measure = 
var check =
    COUNTROWS(
        FILTER(
            VALUES( 'Table'[audit type] )
            , 'Table'[audit type] in { "expired" , "missing" }
        )
    )
return
IF( ISBLANK( check ) , TRUE() , FALSE() )

Regards,

Tom

[Nepal101]

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?

Var check=

countrows(

Filter(

VALUES('TabIe'[AuditTypeKey])

,'Table'[AuditTypeKey] in

{1,3,4}

)

)

Return

If(ISBLANK(check),True(),False())

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.