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.
Hi,
I have the table in PowerBI similar to the one below.
What I'm aiming to do is rank the Column Headings based on the frequency of a value in the column.
For example, frequency of the text "Fail" in column B is 4, frequency of "Fail" in column C is 2, frequency column D is 1, column E is 5
Rank would be:
1. Is this cool?
2. Is this suitable?
3. Is this compliant?
4. Is this realistic?
I've created a measure for each column to count the number of "Fail"
FAILCOUNT = CALCULATE(COUNTROWS('table'),'table'[Is this sitable?]="Fail")
I'm not sure where to go from here..any advice would be great.
Thanks
Solved! Go to Solution.
@Anonymous
in PQ, select ID column and unpivot other columns
create a measure
failcount = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Value]="Fail"))
rank = RANKX(ALLSELECTED('Table'[Attribute]),[failcount],,DESC)
Proud to be a Super User!
@Anonymous
in PQ, select ID column and unpivot other columns
create a measure
failcount = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Value]="Fail"))
rank = RANKX(ALLSELECTED('Table'[Attribute]),[failcount],,DESC)
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |