Calculate 25 percentile for transactions happened in 15 mins

[New123]

Hi Everyone,

Can someone please help me to calculate 25th percentile for total transactions happened in 15 mins for a particular product.

Date	product	hour	15mins	total_txns
01/07/2022	A	8	8:30:00AM	255
01/07/2022	A	8	8:45:00AM	284
01/07/2022	A	9	9:00:00AM	281
01/07/2022	B	9	09:15:00AM	280
02/07/2022	A	10	10:00:00AM	400
01/07/2022	A	10	10:15:00AM	400
01/07/2022	B	10	10:45:00AM	182
01/07/2022	B	11	11:45:00AM	182
01/07/2022	A	12	12:00:00AM	254
01/07/2022	A	12	12:15:00AM	65
01/07/2022	A	16	16:00:00AM	6

can we make this dynamic and filter with product and date?

Thank you

[amitchandak]

@New123 , Based on Now()  and Now() - time(0,15,0) you can have measure for last 15 Mins

for percentile you can refer

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

[New123]

Hi amitchandak,

Thanks for the response but I'm not getting what I want, may be because I'm new to dax .

thanks