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.
I saw another post that counts a especific value:
ColumnName1 = CALCULATE ( COUNTROWS (Table 1), Table 1[fieldName] = "Value")
I don't want to choose a constant value, I'd like to build a column that counts using a value from a column. Example:
Colors Count
Blue 3
Blue 3
Blue 3
Yellow 2
Yello 2
How to parse the Color column?
Solved! Go to Solution.
Hi. Use a new calculated column with this Code:
Column = COUNTROWS ( FILTER ( Table1, Table1[Color] = EARLIER ( Table1[Color] ) ) )
Hi. Use a new calculated column with this Code:
Column = COUNTROWS ( FILTER ( Table1, Table1[Color] = EARLIER ( Table1[Color] ) ) )
That "EARLIER" function is what I need! Thank you! Marked as answered.
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |