Simple countif

[Edmundas]

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.

 

[BeaBF · Accepted solution]

@Edmundas Hi!

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

BBF

[Edmundas]

Thanks guys, both formulas worked!!!

[BeaBF]

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

BBF

[Jihwan_Kim · Accepted solution]

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

[BeaBF · Accepted solution]

@Edmundas Hi!

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

BBF