How to filter within a measure?

[jsw94]

Hello,

I'm very new to Power BI. I'm trying to create a single funnel to show a pipeline of partner companies for materials sourcing. I have created a custom measure that makes these stages add up cumulatively in the funnel.

Here is part of my table:

My measure: 

Count of Current Status running total in Current Status 2 =

CALCULATE(

    COUNTA('Potential partners'[Current Status]),

    FILTER(

        CALCULATETABLE(

            SUMMARIZE('Status', 'Status'[Order], 'Status'[Current Status]),

            ALLSELECTED('Status')

        ),

        ISONORAFTER(

            'Status'[Order], MIN('Status'[Order]), ASC,

            'Status'[Current Status], MIN('Status'[Current Status]), ASC

        )

    )

)

And my funnel:

I would like to include the "Disqualified" stages in my main funnel, but I do not want those numbers to be cumulative. How can I exclude them so that "Disqualified - Preliminary" stays 3, instead of becoming 6 when added to the main funnel with the measure included. In this case, "Inquired Made" would equal 28 and preliminary discussions would be 9 because those three that have been disqualified would be counted in the main funnel.

[lbendlin]

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.

[jsw94]

Could you point me to resources on how to do so?

[lbendlin]

Use variables to improve your DAX formulas - DAX | Microsoft Learn