Quartile in dax

[GBarreto1]

I need to calculate the quartile on a measure but I am unsuccessful in my attempts, I am trying as follows:
     Define Measure 'Table' [MyMeasure] = PERCENTILEX.EXC (ALL (dProgram [NM_PROGRAM]), [% PAUSE], 0.75)

where [% PAUSE] is as I need to get the quartile

[Anonymous]

Hi @GBarreto1 

You can try the following measure

[MyMeasure] = CALCULATE(PERCENTILEX.EXC (dProgram, [% PAUSE], 0.75),ALL (dProgram [NM_PROGRAM]))

Best Regards!

Yolo Zhu

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

[GBarreto1]

I forgot to mention, I have this view of the pause measure grouped by date and program, I need to calculate the quartile of this pause view that is generated

[amitchandak]

@GBarreto1 , refer if video from Curbal can help

https://curbal.com/blog/glossary/percentilex-exc-dax

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
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156

Or Window function

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[GBarreto1]

Basically, I set up this view to bring the pauses grouped by date and program, I need the quartile based on this pause measure that is generated