Forum Discussion
Solved
AVG instead Total in matrix
Hi all, I need know if I can change the Total Value for AVG, but in the same column that totals are showing. I've try with these formula 1.- S = SUM(FACT_SALES_ST[Net]) 2.- AVG = AVERAGEX(V...
Hello, ivancornejo_
I tested new formula and get needed result.AVG =
AVERAGEX (
ADDCOLUMNS (
SUMMARIZE ( FACT_SALES_ST; DIM_PRODUCT_ST[Product_division] );
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
)
Hello, ivancornejo_
I tested new formula and get needed result.
AVG =
AVERAGEX (
ADDCOLUMNS (
SUMMARIZE ( FACT_SALES_ST; DIM_PRODUCT_ST[Product_division] );
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
)
