Forum Discussion
Dynamic RANKX with Slicer and 2 Groups
Hi CamIAm88 ,
You can share the pbix file by onedrive then post the link or you can share the screenshot.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CamIAm88 , why rank is 6,6, 3
Rank can be done like. assume [Hour Worked] is measure in which you want rank
Rankx(All(Table[Work_Type]) , [Hour Worked], ,desc,dense)
or
Rankx(Allselected(Table[Work_Type]) , [Hour Worked], ,desc,dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
Hi Amit - please allow me to elaborate.
I have a dashboard tab with two slicers (employee and date). This interacts with a table that displays certain KPIs. I want to rank according to items per minute which are shown in the column '# Ranking_Calculate'. The same formula is being used for # Ranking_Calculate as is being used in the RANKX formula.
Ranking Formula:# Ranking =RANKX(FILTER(Machine_Data_Agg, Machine_Data_Agg[job_name] = MIN(Machine_Data_Agg[job_name]) ),DIVIDE(CALCULATE(SUM(Machine_Data_Agg[total_item_input])),CALCULATE((SUM(Machine_Data_Agg[total_seconds_idle]) +SUM(Machine_Data_Agg[total_seconds_jammed]) +SUM(Machine_Data_Agg[total_seconds_running]))/60)),,ASC,Dense)
Image of Current Outcome:
