Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |