Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
What would be the appropriate formula to create this measure in Power BI?
Thanks for the tip
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)))))
User | Count |
---|---|
101 | |
90 | |
83 | |
72 | |
66 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |