Forum Discussion

owenv's avatar
owenv
Frequent Visitor
4 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    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.