Nested Count If statement in expression help

[Anonymous]

Annual
Backup
Complete
Owner

I have a pivot table with columns similar to the above. I would like to do another chart that only counts cells that do not show as  "Complete". I tried the below formula but its not working, does anyone have any suggestions?

If(([Annual] <> 'Complete'),Count[Annual], Null())

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

Count({<Annual -= {"Complete"}>} Annual)

[Anonymous]

doesnt the field have to be in brackets "[]" it doesnt pick it up otherwise for me