I am trying to figure out the percentage of agents (customers) that have only ordered 1 inspection (an inspection for us is an order) per franchise location.
We have an orders table. I have a measure that calculates the inspections [Inspections = COUNT(‘Orders Table’[oid])] where the OID is the Order ID. How do I determine the percentage of agents that only ordered once (1 order agents / all agents where inspection count is greater than 0)?
Desired output will be a KPI that shows percentage of ‘One Off’ agents per location.
I have include a sample of Orders Table, Agents Table, Franchise Table and a table called ISN ID that links them together.