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 

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