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