Forum Discussion
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 calcu...
ApurvaKhatri Hello, please share your dataset
I wont be able to share the actual dataset. However, the dummy set is:
| Sales Manager | UnitsLeased |
| A | 2 |
| B | 5 |
| C | 7 |
| D | 9 |
UnitLeased is a measure.
Also, I have a date slicer that has hierarchy of Year- Month
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
Thanks for the help. But that doesnt work as expected.