Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I have a set of data that has thousands of rows. There is a column that lists a rating of "At/Above Average". How would I create a measure that calculates how many rows have the value of "At/Above Average" in columnA and divides that by the total number of rows?
@Anonymous
At or Above Average = COUNTROWS ( FILTER(table, table[Column]="At/Above Average") )
Total Rows = CALCULATE ( COUNTROWS (table), ALL(table) )
% At or Above Average = DIVIDE ( [At or Above Average], [Total Rows], 0 )
I followed these instructions exactly and am not getting correct results