Count

[et21]

hi all, I got a question about count. i want to count how many of this data got Not Stated in there but somehow I can't figure it out how to do it yet.
here is the eg:
Data Item 1 contain: On Plan, Not Stated
Data Item 2 contain: In Trouble, Not Stated
Data Item 3 contain: In Trouble, Not Stated

result I want it count how many Not Stated in those 3 Data Items

Cheer
Thank you

[werdunloaded]

Here are two ways to achieve this:

• COUNT(CASE WHEN [Stated Status] = 'Not Stated' THEN [Stated Status] else null)
• TOTAL(CASE WHEN [Stated Status] = 'Not Stated' THEN 1 ELSE 0)