Calculate a percentage of rows based on 2 Column criteria

[scottm0690]

I have a sheet that i am trying to calculate percentage based on a couple things. 

1) if "Audit Type" column contains certain text (for this example it is "SOC")

2) If "State" column contains another certain text (for this example it is "In Auditor Review")

If Auditor type = SOC and State = In Auditor Review, add them to get number "A"

Then count the number of rows that = SOC (for this example is 9)

Divde A/9 to get a percentage of ones that are In Auditor Review.  Which is .666, or 67%.  

Not sure if this is possible.  Wanted to ask the experts. 

Thank You 

[parry2k · Accepted solution]

@scottm0690 add following measure and that will do it:

Total Count = COUNTROWS ( YourTable )

Percentage = 
DIVIDE ( 
   CALCULATE ( [Total Count], YourTable[Audit Type] = "SOC", YourTable[State] = "In Auditor Review" ),
   CALCULATE ( [Total Count], YourTable[Audit Type] = "SOC" )
)

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️