Forum Discussion

CamIAm88's avatar
CamIAm88
Regular Visitor
3 years ago
Solved

Dynamic RANKX with Slicer and 2 Groups

I'm using a table to display metrics for all [Work_Type] for the employee and date range selected from a slicer. For example, if selecting Employee A and date range 1/2/2022 and 1/2/2022, the table w...
Need Help
  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    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's avatar
CamIAm88
Regular Visitor
3 years ago

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: