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)   ...
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
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

    • aso1's avatar
      aso1
      Helper II
      6 years ago

      getting this error.

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