TOP Achiever Analysis

Romani You can try with this new flag measure:

To ensure the correct implementation of ranking measures and flags for "Return on Sales (ROS)" in Power BI, I should follow these steps:

1. Create the column for overall ROS ranking:

   ROS Rank = RANKX( ALL('Credit Benchmarking'), 'Credit Benchmarking'[Return on Sales (ROS)], , DESC, DENSE )

2. Create the column for ROS ranking based on year, industry, category, and sub-industry:

   ROS Rank_year_industry_category_subindustry = VAR CurrentYear = 'Credit Benchmarking'[Date] VAR CurrentIndustry = 'Credit Benchmarking'[Industry GB Lease Classification] VAR CurrentCategory = 'Credit Benchmarking'[Category] VAR CurrentSubIndustry = 'Credit Benchmarking'[Sub-Industry (level 4)] RETURN RANKX( FILTER( ALL('Credit Benchmarking'), 'Credit Benchmarking'[Date] = CurrentYear && 'Credit Benchmarking'[Industry GB Lease Classification] = CurrentIndustry && 'Credit Benchmarking'[Category] = CurrentCategory && 'Credit Benchmarking'[Sub-Industry (level 4)] = CurrentSubIndustry ), 'Credit Benchmarking'[Return on Sales (ROS)], , DESC, DENSE )

3. Create the measure to flag the top rankings based on the selected criteria:

   Flag_TOP = VAR year_selected = IF(HASONEVALUE('Credit Benchmarking'[Date]), "TRUE", "FALSE") RETURN IF( (year_selected = "TRUE" && SELECTEDVALUE('Credit Benchmarking'[ROS Rank_year_industry_category_subindustry]) <= 'Ranking Selection'[Ranking Select]) || (year_selected = "FALSE" && SELECTEDVALUE('Credit Benchmarking'[ROS Rank]) <= 'Ranking Selection'[Ranking Select]), "TRUE", "FALSE" )

Despite following these steps, I am not getting the desired output. Specifically, when choosing the rank without considering the year, it does not reflect correctly.

Romani ok, can you share the pbix file or some sample data on which you are calculating this?

Sample data - expected output.

BBF

Romani have you put both the calculated column as tooltip in the visual?

RomaniI probably understood, the first formula must be like this:

ROS Rank = VAR CurrentIndustry = 'Credit Benchmarking'[Industry GB Lease Classification] VAR CurrentCategory = 'Credit Benchmarking'[Category] VAR CurrentSubIndustry = 'Credit Benchmarking'[Sub-Industry (level 4)] RETURN RANKX( FILTER( ALL('Credit Benchmarking'),  'Credit Benchmarking'[Industry GB Lease Classification] = CurrentIndustry && 'Credit Benchmarking'[Category] = CurrentCategory && 'Credit Benchmarking'[Sub-Industry (level 4)] = CurrentSubIndustry ), 'Credit Benchmarking'[Return on Sales (ROS)], , DESC, DENSE )

Try.

BBF

no it doesnt work 

Romani what it's not working?

BBF

what i want when iam chosing the rank without year to reflect on the visuals
and when iam chosing the industry and rank it reflect too on the visuals 
i dont want my ranking to be reflect if iam chosing one filter or iam choosing more than one

Romani Can you explain with some examples? on the last pbix i 've sent to you, so that we can restart from that point.

BBF

I didnt get any answer from your side

Romani i wrote you if you can explain the problem with some examples on the last pbix i 've sent to you, so that we can restart from that point.

BBF

Please check your email