cancel
Showing results for
Did you mean:

## 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

1 ACCEPTED SOLUTION
Super User

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
2 REPLIES 2
Super User

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hello @TomMartens
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.

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

#### Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors