Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
38 | |
30 |