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

popov's avatar
popov
Resolver III
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]
)

  • ivancornejo_'s avatar
    ivancornejo_
    Frequent Visitor
    8 years ago

    Fantastic popov ! 

     

    Thanks a lot :) 

  • 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!
  • harib's avatar
    harib
    Post Patron
    7 years ago

    ivancornejo_ 

    HI 

    can u share the link of sample PBIX file. I have same senario.

     

    Thanks 

     

  • popov's avatar
    popov
    Resolver III
    7 years ago

    Hello, Anonymous,

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