Percentile with 2 values

[desiiirz]

Hello,

I have one measure for the revenue :  CA HT = SUM(Ventes[Prix Vente HT])

Another for the previous year :           CA HT PY = CALCULATE([CA HT],SAMEPERIODLASTYEAR(Dates[Date]))

I tried : ((measure1 - measure2) / measure 2) * 100 but it didn't work

How can i calculate the percentile between the measure 1 and measure 2 ?

Ex        ((100 - 90) / 90) * 100 = 11,11%

[amitchandak]

@desiiirz , I assume % not percentile

divide([M1] -[M2],[M2]) 

and mark that as % column

for percentile

Top 80/20 , percent /percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459

Power BI Window function- Pareto Analysis, 80% of sales, Order by on Measure: https://www.youtube.com/watch?v=UVxiLc_AzSs

[desiiirz]

Hello  @amitchandak  , yes it's % ! 

The measure seems to work, however the value seems odd, i have 0k%