Forum Discussion
Create calculated Table with conditions
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.
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
2 Replies
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
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}))ReturnIf(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.
