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.
Go to Solution.
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!
View solution in original post
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!