Forum Discussion

aso1's avatar
aso1
Helper II
6 years ago
Solved

Create simple card - ok/error

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

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    aso1 , you can get last status like

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

     

     

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    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's avatar
      aso1
      Helper II
      6 years ago

      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's avatar
        v-lili6-msft
        Community Support
        6 years ago

        hi  aso1 

        Adjust the formula as below:

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

         

        Regards,

        Lin