Forum Discussion

RaffiKouzoudj's avatar
RaffiKouzoudj
Helper 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.

     

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
Helper 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
    Super 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))