Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |