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.

ribisht17's avatar
ribisht17
Super User
4 years ago

owenv 

This should work >>>

 

Step 1

Total Vehicle = COUNTX(ALL(Vehicle), Vehicle[vehicle])
 
Step 2
Total Pass Vehicle = CALCULATE(count(Vehicle[Total Vehicle]),FILTER(all(Vehicle),Vehicle[pass]=true()))
 
Step3
Final % = [Total Pass Vehicle]/min(Vehicle[Total Vehicle])*100
 

 

Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users