Countrows by ID

[PowerBI123456]

Hi, this seems like it would be simple to do, but I cant figure it out. How can I countrows by ID via a measure? For example, ID 1 has 4 rows. Thanks!

[az38 · Accepted solution]

Hi @PowerBI123456 

I prefer this one

Measure = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[ID]))

[PowerBI123456]

@az38 Thanks! But that is counting all the rows for me. I want to count it by ID. 

[az38]

@PowerBI123456 

also you can create a calculated table

New Table = SUMMARIZECOLUMNS('Table'[ID], "Count By ID", COUNT('Table'[ID]))

[az38]

@PowerBI123456 

it will count rows exactly by ID

[PowerBI123456]

@az38 

See below, I am doing the calc the same way, but its returning the number of total rows in that table. 

[az38]

@PowerBI123456 

it depends on visual. if you put in the table [Unique] field and your measure - you will get a desired result

BUT. if you have the only column - [Unique] create a super simple measure

Measure = COUNTROWS('Table')

[PowerBI123456]

@az38 thanks!