Forum Discussion

ApurvaKhatri's avatar
ApurvaKhatri
Helper III
7 years ago

Calculating Percentile on Measure

Hi,

 

I have a measure in my powerbi report. I am trying to calculate the percentile on the measure [UnitsLeased] and table1.

 

However, when I apply the formula, I do not get the option of calculating the percentile for measure. Please help.

Need Help

11 Replies

    • ApurvaKhatri's avatar
      ApurvaKhatri
      Helper III
      7 years ago

      I wont be able to share the actual dataset. However, the dummy set is:

       

      Sales ManagerUnitsLeased 
      A2
      B5
      C7
      D9

       

      UnitLeased is a measure.

      Also, I have a date slicer that has hierarchy of Year- Month

      • LivioLanzo's avatar
        LivioLanzo
        Solution Sage
        7 years ago

        ApurvaKhatri

         

        I won't be able to provide the exact measure without seeing the model. But in general you can do something like this:

         

        PERCENTILEX.INC( VALUES(Sales[Sales Manager] ), [UnitsLeased], 0.9 )

         

        you will need to adapt this to your needs

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi ApurvaKhatri,

     

    Have you solved your problem?

     

    If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please share your desired output.

     

    Best  Regards,

    Cherry