Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
I prefer this one
Measure = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[ID]))
I prefer this one
Measure = CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[ID]))
@az38 Thanks! But that is counting all the rows for me. I want to count it by ID.
also you can create a calculated table
New Table = SUMMARIZECOLUMNS('Table'[ID], "Count By ID", COUNT('Table'[ID]))
it will count rows exactly by ID
See below, I am doing the calc the same way, but its returning the number of total rows in that table.
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')
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |