PBI Formula to divide two value and filter

[Dimitri70]

Hello,

I'm new in Power BI and I've been trying to create a formula to divide two value but while filtering the row.

Example below, I would like to divide the Count (on time)/Count (Total) only for the row where in Colunm "Month" I have "Result"

So for example below= 224/322=0.695

Plant Description	Months	Count(Not On time)	Count(On time)	Count(Total)
abc	Result	98	224	322
abc	05.2024	20	56	76
abc	06.2024	20	24	44
abc	07.2024	34	49	83
abc	08.2024	5	15	20
abc	09.2024	16	51	67
abc	10.2024	3	29	32

Do you have any idea how I can proceed?

Thank you in advance for your support

[lbendlin · Accepted solution]

[Dimitri70]

Thank you