Forum Discussion

RaffiKouzoudj's avatar
RaffiKouzoudj
Icon for Helper III rankHelper III
5 years ago
Solved

Calculate Average per category

 

Hello,

I want to calculate the Average (mean) of the 2020 and 2021 based on the values on the above table.

Example: (3792 + 3082 + 3337 + 3199) / 4

 

Any help!

thank You

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    You don't show the model, so I can only give you a very general formula...

     

    [Measure] =
    AVERAGEX(
        DISTINCT( T[Month] ),
        [Your Base Measure]
    )
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi RaffiKouzoudj

     

    Please try measure as：

    Measure = 
CALCULATE(
    AVERAGEX(DISTINCT（Sub_main [Month]），Sub_main [Total]),
    ALL('Table')
)

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You don't show the model, so I can only give you a very general formula...

     

    [Measure] =
    AVERAGEX(
        DISTINCT( T[Month] ),
        [Your Base Measure]
    )
    • RaffiKouzoudj's avatar
      RaffiKouzoudj
      Icon for Helper III rankHelper III
      5 years ago

      Dear Daxer,

       

      I used the formula you suggested however, i am getting the same values as the first column.

       

      1) Total = SUM(Sub_main[2021])

      2) Measure = AVERAGEX( DISTINCT(Sub_main[Month] ), Sub_main[Total]).

       

       

      thank you

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        5 years ago

        RaffiKouzoudj 

        maybe you can try

        VAR _max=calculate(max(date),all(table))

        return divide(calculate(sum(value),filter(all(table),year(date)=2021)), month(_max))

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi RaffiKouzoudj

     

    Please try measure as：

    Measure = 
CALCULATE(
    AVERAGEX(DISTINCT（Sub_main [Month]），Sub_main [Total]),
    ALL('Table')
)

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Where do you want to see the average?  In the total row or on a card visual.  Show the expected result very clearly.  Also, share the link from where i can download your PBI file.