Forum Discussion

mohany2211's avatar
mohany2211
Frequent Visitor
7 years ago
Solved

Count of similar value in multiple Rows

Hi...I have a table in powe bi where i have multiple similar value in rows and i want a count of the total values of similar value in each row, something like this. Pls advise the formula for the same

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Try adding a calculated column to your table and adding the below:

     

    Column =
    COUNTX (
        FILTER (
            Table1,
            Table1[Entity] = EARLIER ( Table1[Entity] )
        ),
        Table1[Entity]
    )

     

    where Table1 is your table.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Try adding a calculated column to your table and adding the below:

     

    Column =
    COUNTX (
        FILTER (
            Table1,
            Table1[Entity] = EARLIER ( Table1[Entity] )
        ),
        Table1[Entity]
    )

     

    where Table1 is your table.

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago
    Hi
    You can use a calculated column like

    =calculate(countrows (table1), allexcept(table1, table1[entity]))