Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
Two parts to this question:
1. I have data that is based on responses where the respondent is presented with a list of options and selects either Yes or No depending on whether the option is important to them.
Data of a count of all the 'YES' responses is currently shown in a table:
I've been trying to add a ranking column to the table without much success.
The measure I've been trying to do this with is:
Solved! Go to Solution.
Hi @Fusilier
Create this as a new measure, make sure to put your own table and column names in
Rank Questions =
RankX( --Performs an expression for each row
AllSelected('Combined Table'[Question]) --Remove internal filters keeps external
,Calculate(Count(Combined Table'[Answer])) --Calculate applies a fitler
,DESC --Sort most to least
,Skip--If 2 questions rank 1st, third question gets 3nd not 2nd
)
Apply this measure in Cell elements click the Fx symbol and change the Format Style to Field value
Colour rank =
If( [Rank Questions] <= 3, "Green", "Red")
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @Fusilier
Create this as a new measure, make sure to put your own table and column names in
Rank Questions =
RankX( --Performs an expression for each row
AllSelected('Combined Table'[Question]) --Remove internal filters keeps external
,Calculate(Count(Combined Table'[Answer])) --Calculate applies a fitler
,DESC --Sort most to least
,Skip--If 2 questions rank 1st, third question gets 3nd not 2nd
)
Apply this measure in Cell elements click the Fx symbol and change the Format Style to Field value
Colour rank =
If( [Rank Questions] <= 3, "Green", "Red")
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Thank you. Works great!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.