How to count column with filter

Question

I want to count column Status2020 not equal B and Status2021 = B

I use the formula as below.

COUNT(('Before 2021'[Status(2020)]),

FILTER('Before 2021','Before 2021'[Status(2020)]<>"B") && 'Before 2021','Before 2021'[Status(2021)]="B"))

But formula error.

Please guide me about it.

vanessafvg · Accepted Answer

what are you trying to do?&nbsp; ive reformatted it below but not sure what your objective is.
&nbsp;
measure&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;COUNT&nbsp;(&nbsp;'Before&nbsp;2021'[Status(2020)]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Before&nbsp;2021',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Before&nbsp;2021'[Status(2020)]&nbsp;&lt;&gt;&nbsp;"B"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;'Before&nbsp;2021'[Status(2021)]&nbsp;=&nbsp;"B"&nbsp;&nbsp;&nbsp;&nbsp;))

Forum Discussion

How to count column with filter

2 Replies

Related content

Total Count in Column

Filter participant counts

Filter and Count

Slicer for filtering several columns

Counting nulls