Calculate a percentage in a column

[PBIBeginner2022]

Hi everyone,

I need to create a mesure which calculate a percentage in my column. I have 6 differents values in a column of 300 000 rows.

I need to calculate in percentage the number of rows contain "On time" divided by the number total of rows.

Thanks in advance for any help.

[amitchandak · Accepted solution]

@PBIBeginner2022 , Try a measure like

divide(Countrows(Filter(Table, Table[column] = "On Time")), Countrows(Table))

or

divide(Countrows(Filter(Table, Table[column] = "On Time")), Countrows(allselected(Table)))