Create simple card - ok/error

[aso1]

I have a daily job where I press the 'date-in' filter on a daily basis (lower left in the report), and I check to see if 'Status' is OK down the list or not. 

(here is my actual report)

I want to make this smarter... by having a card that basically says "OK" or "ERROR". 

The card must check the latest date (date_in), then it must check to see if all items in 'Status' is OK. 

if all items are OK - then type "OK" If it is not ok - then the card must type "ERROR".  

How can I achieve this?

thanks in advance

[v-lili6-msft]

hi @aso1 

Create a measure like this 

Result =
IF (
    CALCULATE ( COUNTA ( 'Table'[Status] ), 'Table'[Status] <> "OK" ) > 0,
    "ERROR",
    "OK"
)

Then drag this measure into card visual.

Regards,

lin

[aso1]

wow!.. perfect!!.. this works. 

however, I just need to filter out 'Tempdb' out. I dont need a check on that database. 

if tempdb is out of this list, then I will have 100% OK. 

I tried filtering it out in the report .. but that still gave me "ERROR / NOT OK" in the card. 

Can you put a exclude in the result, so it wont check for the tempdb database?.. 

[v-lili6-msft]

hi  @aso1 

Adjust the formula as below:

Result =
IF (
    CALCULATE ( COUNTA ( 'Table'[Status] ), 'Table'[Status] <> "OK"&&'Table'[database]<> "Tempdb") > 0,
    "ERROR",
    "OK"
)

Regards,

Lin

[aso1]

getting this error.

[v-lili6-msft · Accepted solution]

hi  @aso1 

I'm sorry for my carelessness, please use "," instead of "&&" in the formula

Result =

IF (

CALCULATE ( COUNTA ( 'Table'[Status] ), 'Table'[Status] <> "OK",'Table'[database]<> "Tempdb") > 0,

"ERROR",

"OK"

)

Regards,

Lin

[amitchandak]

@aso1 , you can get last status like

lastnonblankvalue(calllog[Date],max(calllog[status]))