Calculate Average per category

[RaffiKouzoudj]

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

[Anonymous · Accepted solution]

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 · Accepted solution]

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]

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.

[Anonymous · Accepted solution]

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]

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]

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