how to calculate percentile of a calculated measure

[UditJ]

i have a calculated measure and need to find percentile of that. 

Any suggestions ?

[Anonymous]

Hi @UditJ ,

I think you can try what-if-paramter .

In addition to creating the parameter, creating a what-if parameter also creates a measure[Parameter Value]. You can replace the third parameter in the function PERCENTILEX.INC with [Parameter Value].

You can change you original measure as below:

Percentile=
PERCENTILEX.INC (
    'Table',
    'Table'[measure],
    [Parameter Value]
)

You also can refer to the following posts that may be helpful to you:

Percentile over a measure - Microsoft Power BI Community

Need to create measure that calculates percentile - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider  Accept it as the solution  to help the other members find it more quickly. 

[AbbasG]

@UditJ this post will guide you in the right direction.

https://community.powerbi.com/t5/Desktop/Calculating-Percentile-on-Measure/m-p/548750