Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @fernandoC ,
Please see the below screenshot, I think that's what you want.
Funnel = CALCULATE (
COUNTROWS('Main Jira Info'),
FILTER (
ALL ( 'Main Jira Info'[Status Order Complete], 'Main Jira Info'[Status Name Complete] ),
'Main Jira Info'[Status Order Complete] <= MAX('Main Jira Info'[Status Order Complete]) && NOT(ISBLANK('Main Jira Info'[Status Name Complete]))
)
)
Please try.
Aiolos Zhao
Proud to be a Super User!
Hi @fernandoC ,
I tried it on my desktop, it works. Please see the below screenshot.
If it's not worked on your side, could you please show your data model and it's better to give a pbix to us.
Measure 9 = CALCULATE(COUNTROWS('Table (3)'),FILTER(ALL('Table (3)'[Order],'Table (3)'[Name]),'Table (3)'[Order] >= MAX('Table (3)'[Order])))
Thanks.
Aiolos
Proud to be a Super User!
Hi @AiolosZhao ,
I've uploaded the pbix file to Drive. Please use the following link: https://drive.google.com/file/d/1KalG1Sf_OrWdG5EB1Szvcg9qwutq-fhR/view?usp=sharing
Thanks again!.
Best,
Hi @fernandoC ,
Please see the below screenshot, I think that's what you want.
Funnel = CALCULATE (
COUNTROWS('Main Jira Info'),
FILTER (
ALL ( 'Main Jira Info'[Status Order Complete], 'Main Jira Info'[Status Name Complete] ),
'Main Jira Info'[Status Order Complete] <= MAX('Main Jira Info'[Status Order Complete]) && NOT(ISBLANK('Main Jira Info'[Status Name Complete]))
)
)
Please try.
Aiolos Zhao
Proud to be a Super User!
Hi @AiolosZhao ,
Thank you for your help on this!.
The formula worked 🙂 I only needed to make a quick fix to it as with the current formula it wasn't organizing the steps based on the order number.
The final formula looked like this:
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |