topic Re: Simple countif in DAX Commands and Tips

Simple countif

Edmundas — Wed, 16 Nov 2022 09:01:00 GMT

Hi everyone,

I'm quite new on Power BI. Could you please help me to write formula in Power BI column (COUNTIF formula in picture below). Thank you in advance.

Re: Simple countif

BeaBF — Wed, 16 Nov 2022 09:38:23 GMT

Edmundas Hi!

= CONTAINS('Table','Table'[Random names], 'Table'[Employee]) + 0

BBF

Re: Simple countif

Jihwan_Kim — Wed, 16 Nov 2022 09:38:45 GMT

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Expected result CC = COUNTROWS ( SUMMARIZE ( FILTER ( Data, Data[Employee] = EARLIER ( Data[Employee] ) && Data[Employee] IN DISTINCT ( Data[Random name] ) ), Data[Employee] ) ) + 0

Re: Simple countif

Edmundas — Wed, 16 Nov 2022 10:16:18 GMT

Thanks guys, both formulas worked!!!

Re: Simple countif

BeaBF — Wed, 16 Nov 2022 10:19:53 GMT

Edmundas However, I advise you to adopt mine, as it is computationally lighter.

BBF