Forum Discussion

fernandoC's avatar
fernandoC
Icon for Helper V rankHelper V
5 years ago
Solved

Funnel 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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        fernandoC
        Icon for Helper V rankHelper V
        5 years ago

        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.