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.
Good Afternoon,
If i create a variable using summarizecolumns like so:
How would i then use this to count the "count" column
Solved! Go to Solution.
@sovereignauto With the table summarized, counting the count column is the same as counting the rows in the table so you can use COUNTROWS. You could also use COUNTX or any of the other X aggregation functions if you wanted to be specific about the column or wanted an aggregation like sum, SUMX(_data,[count]).
@sovereignauto With the table summarized, counting the count column is the same as counting the rows in the table so you can use COUNTROWS. You could also use COUNTX or any of the other X aggregation functions if you wanted to be specific about the column or wanted an aggregation like sum, SUMX(_data,[count]).
@Greg_Deckler Do you know why i would be getting the error:
ah so simple! i was having a moment and was just trying count() rather than countx!
ended up using count rows as per your advice!
thank you!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |