Forum Discussion

Sri_phani's avatar
Sri_phani
Icon for Helper III rankHelper III
2 years ago
Solved

Show Rank in Card visual

Hi,    I need help with creating a LOB-wise rank for the agent and a team-wise rank for the agent in the card. Condition: The agent can change the LOB hence we have to check what is the agent's cu...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

I am not sure if I understood your question correctly, but please try something like below whether it suits your requirement.

 

Rank: = 
RANKX(ALL('All Metrics One Place'[Employee Name],'All Metrics One Place'[Site + LOB]), [Resolve attainment],,DESC,Dense)

 

  • Sri_phani's avatar
    Sri_phani
    Icon for Helper III rankHelper III
    2 years ago

    No, this measure is not working. I tried something like this. This is working perfectly in table. but not in measure. 

    Test rank =
    VAR Tabled =
        SUMMARIZE(
                    FILTER(
                        'All Metrics One Place',
                        'All Metrics One Place'[Date] <= MAX('All Metrics One Place'[Date]) &&
                        'All Metrics One Place'[Date] >= MIN('All Metrics One Place'[Date]) &&
                        'All Metrics One Place'[Site + LOB] = SELECTEDVALUE('All Metrics One Place'[Site + LOB])
                    ),
                    'All Metrics One Place'[Employee Name],
                    'All Metrics One Place'[Site + LOB]
                ,
                "Resolve Numerator", SUM('All Metrics One Place'[Resolve Numerator]),
                "Resolve Denominator", SUM('All Metrics One Place'[Resolve Denominator]))
    VAR newtable = ADDCOLUMNS(Tabled, "Resolve1", [Resolve Numerator]/[Resolve Denominator])
    VAR test1 = ADDCOLUMNS(newtable, "attain", IF( [Resolve1]= BLANK(), BLANK(), [Resolve1]/0.60))
    VAR Ranking = ADDCOLUMNS(test1,"Rank1", RANKX(test1, [attain],, DESC,Dense))
    VAR test2 = FILTER(Ranking, 'All Metrics One Place'[Employee Name] = SELECTEDVALUE('All Metrics One Place'[Employee Name]))
    VAR test3 = SELECTCOLUMNS(test2,"Rank2",[Rank1])

    RETURN
    test3
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Sri_phani 

       

      I think I have understood your request, are you trying to show the level based on the date and employee name selected by the slicer?

       

      But could you please explain "The LOB must consider the current week. For example, Lucifer could have been in any LOB before, but the rank must be calculated based on the current week's LOB." ? How do you determine the LOB for the current week? is it based on the date?

       

      Could you please give the original sample data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show it as screenshot. Please remove any sensitive data in advance.

       

      Best Regards,
      Yulia Xu