Total rows column

[Anonymous]

Hi, I would like to add a column with the sum of total rows.

However, it shows fail if I used "Allselected"

May I ask is there any other measure to achieve the same?

ID	Total rows
1	4
2	4
3	4
4	4

Thanks!

[Arul]

@Anonymous ,

try this or modify based on your requirement,

row count = 
CALCULATE (
    COUNTROWS ( VALUES ( 'tablename'[ID] ) ),
    ALLSELECTED ()
)

Thanks,

[Anonymous]

@Arul still the same error, I think its because of the direct query modeling

So trying to see if any simple DAX can achieve the same.

Thanks