How to calculated the difference from the average of all data

[Anonymous]

I would like to know how to subtract the responding value from the average score in 2021 for all Name

sample data:

Name	id	Date	Score
A	1	1/9/2021	6
B	1	1/7/2021	7
C	1	2/8/2021	8
A	2	1/8/2022	9
B	2	1/6/2022	10

expected outcome:

-2

-1

0

1

2

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

Try formula like below:

Result =
'Table'[Score]
    - CALCULATE (
        AVERAGE ( 'Table'[Score] ),
        ALLEXCEPT ( 'Table', 'Table'[Date].[Year] )
    )

If the problem is still not resolved, please provide a screenshot of the desired result and describe it. Looking forward to your reply.

Best Regards,
Henry

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

[MahyarTF]

Hi,

Create below measure and use it in your visual :

ExpectedVal =

Var _Avg = CALCULATE( AVERAGE(Sheet213[Score]), all(sheet213))

Return CALCULATE(SELECTEDVALUE(Sheet213[Score]) - _Avg)

Thanks for your Kudos and please mark it as a solution if it helps

[Anonymous]

Sorry for confusing what i mean by all data is all name in a specific year, for example, only 2021

[Anonymous]

How about if i would like to to calculate the lastest difference by calculated measure instead of column? is it possible?