Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  POWER BI RANKX function question/problem

    Posted Jan 07, 2022 12:14 PM
      |   view attached
    Hi All.  I am using RANKX to rank Agent Overall Performance metric.  This metric has position and negative percentage values.   If the set of values does not contain a ZERO value, then the RANKX function skips a RANK value.  I attached a csv file since i was unable to paste a picture here.  If you look at rows 82 and 83 highlighted in yellow, then you will see what I am describing.
    Does anyone know how to make the RANKX change this behavior??

    Thanks in advance.

    Celia

    ------------------------------
    Celia Seward
    Business Intelligence Developer
    Haddon Township
    ------------------------------

    Attachment(s)

    csv
    rank.csv   4 KB 1 version


  • 2.  RE: POWER BI RANKX function question/problem

    Posted Jan 10, 2022 10:23 AM
      |   view attached

    Hi Celia,

    I have added the rank in the column with the Dax attached in the PBIX file. Please see attached.

    Let me know if you have further questions. Feel free to check me on LinkedIn  and my website

    Regards,
    Sam Casey Bolade

    ------------------------------
    G Bolade
    RG2 0FZ
    ------------------------------

    Attachment(s)

    pbix
    Rank.pbix   33 KB 1 version