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

Could you share a sample file which can reproduce the issue?

  • 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 :) 

      • 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 

         

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