Forum Discussion
Solved
% based on 2 columns
I have a table of vehicles that have regular inspections. The same vehicle will appear in the table more than once. Sometimes that vehicle will pass an inspection and soemtimes it will fail. I need t...
Hi,
Try these measures:
Row count = COUNTROWS(Data)Pass count = CALCULATE([Row count],Data[pass]=TRUE())Pass % = DIVIDE([Pass count],[Row count])Hope this helps.
The below is an anonymised example. I'd expect to see 50% returned for each vehicle with these values.
| vehicle | pass |
| vehicle 1 | TRUE |
| vehicle 2 | FALSE |
| vehicle 3 | TRUE |
| vehicle 1 | FALSE |
| vehicle 2 | TRUE |
| vehicle 3 | FALSE |
Hi,
Try these measures:
Row count = COUNTROWS(Data)Pass count = CALCULATE([Row count],Data[pass]=TRUE())Pass % = DIVIDE([Pass count],[Row count])Hope this helps.
Many thanks
You are welcome.