I'm new to PowerBI and I've been trying to create a calculated measure that counts the total of rows that = "pass" and divides it by the total number of rows in general. The goal here is to have a graph that shows the percent that reached a benchmark.
I have a column that is of travel times in seconds. I created a new column that distinguished if the travel time was <= 330 'Pass", or >330 'Fail'.
I wish to now show what percent received a 'pass'. Ideally, 90% would receive a pass.