Forum Discussion
fernandoC
Helper V
Helper VFunnel Sorting
Hi Team, I've built a formula based on 2 different columns ("Status Name Complete) & ("Status Order Complete"). These formulas has been used before on other proyects and it works perfectly, howe...
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
fernandoCHelper V
Helper VHi Anonymous ,
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
- fernandoC
Hi Anonymous ,
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:
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]))))
Thanks again for your tremendous help!Best,FC.