The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
@Anonymous ,
try this or modify based on your requirement,
row count =
CALCULATE (
COUNTROWS ( VALUES ( 'tablename'[ID] ) ),
ALLSELECTED ()
)
Thanks,
@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