Forum Discussion

ivancornejo_'s avatar
ivancornejo_
Frequent Visitor
8 years ago
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...
Need Help
  • popov's avatar
    popov
    8 years ago

    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]
    )

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi popov ,

 

I have used your formula, but I am still getting SUM instead of AVG.

Any ideas?

AVG =
AVERAGEX(
ADDCOLUMNS(
SUMMARIZE(product_per_store,'calendar'[Date].[Month]),"Net Value",[dayZ]),[Net Value])
 
Thanks!
popov's avatar
popov
Resolver III
6 years ago

Hello, Anonymous,

You need to use column in table rows instead calendar'[Date].[Month])