A Function Filter has been used in a True/False expression that is used as a table filter expression

[KristinaT]

Hello!

I'm hoping to get an assist.   I have a small table with IDs that can show up more than once in a column and another column that can contain several different values.   I'm attempting to use the ID column as reference to look at any corresponding values in the 2nd column and if it contains "this value" AND NOT "this value", return a value of Pending, otherwise, return a value of Complete.  

I thought I had it worked out, but I am receiving the below error:

A function filter has been used in a True/Fals expression that is used as a table filter expression.  This is not allowed.

I'm still relatively new to DAX and don't know how to fix this.

Any help would be greatly appreciated

Pending Adjustment = 
VAR Count_Pending =
CALCULATE(DISTINCTCOUNT('Presumptive BI'[HAR]), 
FILTER(
    ALLEXCEPT('Presumptive BI', 'Presumptive BI'[HAR]), 'Presumptive BI'[Billing Indicator]) = "FA Presumptive Ready for Write-Off")
VAR Count_Complete = CALCULATE(DISTINCTCOUNT('Presumptive BI'[HAR]), 
FILTER(
    ALLEXCEPT('Presumptive BI', 'Presumptive BI'[HAR]), 'Presumptive BI'[Billing Indicator]) = "FA Presumptive Screening Complete")
RETURN
IF(Count_Pending>0 && Count_Complete>0, "Complete", "Pending")

[Greg_Deckler · Accepted solution]

@KristinaT Proper formatting is your friend...

Pending Adjustment = 
VAR Count_Pending =
CALCULATE(
  DISTINCTCOUNT('Presumptive BI'[HAR]), 
  FILTER(
    ALLEXCEPT('Presumptive BI', 'Presumptive BI'[HAR]), 
    'Presumptive BI'[Billing Indicator] = "FA Presumptive Ready for Write-Off"
  )
)

VAR Count_Complete = 
CALCULATE(
  DISTINCTCOUNT('Presumptive BI'[HAR]), 
  FILTER(
    ALLEXCEPT('Presumptive BI', 'Presumptive BI'[HAR]), 
    'Presumptive BI'[Billing Indicator] = "FA Presumptive Screening Complete"
  )
)
RETURN
  IF(Count_Pending>0 && Count_Complete>0, "Complete", "Pending")

[KristinaT]

Thank you very much - this did the trick!