Count of similar value in multiple Rows

[mohany2211]

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

[robstewart89 · Accepted solution]

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.

[mohany2211]

Thanks...this gave me perfect result

[Zubair_Muhammad]

Hi
You can use a calculated column like

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