Percentiles on a measure

[Syndicate_Admin]

Good afternoon to the whole community.

I have a BI riding with the sales productivity of advisors. In this sense, KPIs are calculated formulas and have different filtering ocpions (date, agency, campaign).

The table is as follows:

And as I want to apply the percentiles is on the sale / hour:

SALE/HOUR ENERGY Advisor =

DIVIDE(sum('Times Integrated Scoreboard Advisor'[ENERGIA]), SUM('Integrated Advisor Marker Times' [Effective Time]))

I apply the different percentiles (

Percentile 100 = PERCENTILEX. INC('Times Integrated Scoreboard Advisor', 'Times Integrated Scoreboard Advisor'[SALE/HOUR ENERGY Advisor],1)) but the results do not make sense.

How can I apply the percentiles to the calculated measure and that varies depending on the filters applied?

[v-easonf-msft · Accepted solution]

Hi, @JoseMJim 

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 (
    'Times Integrated Scoreboard Advisor',
    'Times Integrated Scoreboard Advisor'[SALE/HOUR ENERGY Advisor],
    [Parameter Value]
)

Best Regards,
Community Support Team _ Eason