Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.