Forum Discussion

baptiste23's avatar
baptiste23
Frequent Visitor
7 years ago

Measure with conditions from two columns

Hey guys,

 

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

Below is a sample of my data:

 

StepStatus
OneAccepted
SecondRefused
ThirdWithdrew
FourthRefused
FourthRefused
FourthWithdrew
FourthRefused
FourthAccepted
ThirdAccepted
ThirdRefused
FourthRefused
OneWithdrew
OneAccepted
OneRefused
OneRefused
ThirdWithdrew
ThirdAccepted
SecondWithdrew
SecondAccepted
SecondAccepted

 

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

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.