topic Re: Help ma about Count and filter. in DAX Commands and Tips

Help ma about Count and filter.

Anonymous — Wed, 27 Jan 2021 07:30:53 GMT

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.

AlB — Wed, 27 Jan 2021 07:46:49 GMT

Hi Anonymous

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

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers