Forum Discussion

Edmundas's avatar
Edmundas
Frequent Visitor
3 years ago
Solved

Simple countif

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's avatar
    BeaBF
    3 years ago

    Edmundas Hi!

     

    = CONTAINS('Table','Table'[Random names], 'Table'[Employee]) + 0
     
    BBF
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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

     

4 Replies

    • BeaBF's avatar
      BeaBF
      Super User
      3 years ago

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

       

      BBF

  • BeaBF's avatar
    BeaBF
    Super User
    3 years ago

    Edmundas Hi!

     

    = CONTAINS('Table','Table'[Random names], 'Table'[Employee]) + 0
     
    BBF
  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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