Creating a measure to Rank Columns based on the reoccurrence of specific value

[Marwas]

i am new to DEX, and I am trying to Create a measure to Rank the columns based on the reoccurrence of (3. Not at all confident ) from Highest to lowest.

Thank you

[amitchandak · Accepted solution]

@Marwas , You can create a measures to get this

M1= count(Table[Gate Are setup Properly])

Assume you need rank on customer

Rankx(allselected(Table[Customer]), [M1])

You can consider Rank function too

Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo

Or visual calculation

Power BI Visual Calculations with Rankx, What is Difference between measure and Visual Calculations- https://youtu.be/PGtBsuNWrfw