Measure with conditions from two columns

[baptiste23]

Hey guys,

I'm trying to calculate a measure but currently blocked...

Below is a sample of my data:

Step	Status
One	Accepted
Second	Refused
Third	Withdrew
Fourth	Refused
Fourth	Refused
Fourth	Withdrew
Fourth	Refused
Fourth	Accepted
Third	Accepted
Third	Refused
Fourth	Refused
One	Withdrew
One	Accepted
One	Refused
One	Refused
Third	Withdrew
Third	Accepted
Second	Withdrew
Second	Accepted
Second	Accepted

I would like to calculate the following ratio:

• Numerator equal to the number of status "Withdrew" at step "Third"
• Denominator would be all the status at step "Third" and "Fourth"

What would be the appropriate formula to create this measure in Power BI?

Thanks for the tip

[Anonymous]

Hi @baptiste23 ,

Measure = CALCULATE(DIVIDE(COUNTROWS(FILTER('step-status', FIND("Withdrew", 'step-status'[Status],,0) && FIND("Third", 'step-status'[Step],,0))), COUNTROWS(FILTER('step-status', FIND("Third", 'step-status'[Step],,0) || FIND("Fourth", 'step-status'[Step],,0)))))

Does this work? FYI, 'step-status' can just be substituted for your table name. Hope this helps.