Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |