Measure Optimization - IF() Reduction

Since posting, I've gone another direction, using a combination of SWITCH() and combining all measures into multiple VARs.

To summarize, the measure is calculating total costs (EstimatedTotalCost), determining if an estimate is "Complete" or Incomplete" (Estimate Quality), Counting all estimates (CountAllEstimates), counting all complete estimates (CompleteEstimateCount), and calculating the ratio of complete to total estimates (EstimateQuality%).

In silos, each of the VARs are working as expected, except for CompleteEstimateCount. It counts all rows, not just the rows that EstaimteQuality is calling "Complete".

When I drop the EstimateQuality measure into a data table, it does call out the Sales Orders (SOs) that are and are not "Complete".

This leads me to believe that there is an issue with my COUNTAX() measure.  I have to use Distinctcount() for 'Sales History'[SO] -> There are cases where the SO has multiple service lines.  In those cases, there are two of the same SOs, but I don't want to count it as two.  Using Distinctcount() fixes that problem.

In summary, all of the VARs work in their own silos, when I try to count the "Complete" SOs, the measure counts all of the SOs, not just the ones that EstimateQuality has determined as complete.

Greg_Deckler 

Kudo's to the following post for getting me down this thought process. 
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275

Estimatequality% = 

VAR EstimatedLaborCost =
    SUM ( SalesHistory[Estimated LaborCost] )

VAR EstimatedSubCost =
    SUM ( SalesHistory[Estimated SubcontractorCost] )

VAR EstimatedMaterialCost =
    SUM ( SalesHistory[Estimated MaterialCost] )

Var EstimatedOtherCost = 
    SUM(Sales[Estimated OtherCost])

Var EstimatedTotalCost =
SUMX (
        SalesHistory,
        EstimatedLaborCost + EstimatedSubCost + EstimatedMaterialCost + EstimatedOtherCost
    )

Var EstimateQuality =
SWITCH(
    TRUE(),
        ISBLANK(EstimatedTotalCost),BLANK(),
        EstimatedTotalCost > 0
            && EstimatedMaterialCost = EstimatedTotalCost
            || EstimatedTotalCost = 0 , "Incomplete",
            "Complete"
)

Var CountAllEstimates = 
DISTINCTCOUNT(SalesHistory[SO])

Var CompleteEstimateCount = 
    COUNTAX(FILTER(SalesHistory,estimatequality="Complete"),DISTINCTCOUNT(SalesHistory[SO]))
    
Return

DIVIDE(CompleteEstimateCount,CountAllEstimates)

Anonymous