Summarize ignores context

[6mon]

Can you help me understand the difference between 

SUMX(
    SUMMARIZE(
        FACT_COST_RESOURCE_CATEGORY;
        FACT_COST_RESOURCE_CATEGORY[ID_DIM_PROJECT];
        FACT_COST_RESOURCE_CATEGORY[ID_DIM_ACTIVITY];
        FACT_COST_RESOURCE_CATEGORY[ID_DIM_RESOURCE_CATEGORY];
        "COST PLANNED PROJECT";
        FIRSTNONBLANK(DIM_RESOURCE_CATEGORY[COST_EQUIPMENT_BUDGET];1)
        +
        FIRSTNONBLANK(DIM_RESOURCE_CATEGORY[COST_LABOR_BUDGET];1)
        +
        FIRSTNONBLANK(DIM_RESOURCE_CATEGORY[COST_UNIT_BUDGET];1)
    );
    [COST PLANNED PROJECT]
)

and

SUMX(
    SUMMARIZE(
        FACT_COST_RESOURCE_CATEGORY;
        FACT_COST_RESOURCE_CATEGORY[ID_DIM_PROJECT];
        FACT_COST_RESOURCE_CATEGORY[ID_DIM_ACTIVITY];
        FACT_COST_RESOURCE_CATEGORY[ID_DIM_RESOURCE_CATEGORY]
    );
    FIRSTNONBLANK(DIM_RESOURCE_CATEGORY[COST_EQUIPMENT_BUDGET];1)
    +
    FIRSTNONBLANK(DIM_RESOURCE_CATEGORY[COST_LABOR_BUDGET];1)
    +
    FIRSTNONBLANK(DIM_RESOURCE_CATEGORY[COST_UNIT_BUDGET];1)
)

?

From what I can observe the second one doesn't care for the context.

I'm trying to optimize the top one and altough the second one is much faster (yay!), the results are wrong...

[Anonymous]

Have you tried using GROUPBY, which then gives you access to row context using CURRENTGROUP()

So something like:

GROUPBY(
	TABLE TO GROUP,
	GROUP BY COLUMN,
	GROUP BY COLUMN,
	ETC,
	"Name of New Column",
	SUMX (
		CURRENTGROUP(),
		Expression 
	)
)

Generally dont want to add columns in summarize, better to use ADDCOLUMNS and SUMMARIZE.  

[6mon]

Thanks for the suggestion but FIRSTNONBLANK doesn't seem permitted in the GROUPBY functions...