difference from average

[BiBra]

Hello

I am sitting with a line and clustered column chart, where I have made a measure to show average. 

this is represented by a line. The columns show the individual values. 

Now what I would like to do is use a card (or something like that) to show how far from the average, the individual column is.

(The idea is to pick one specific column, so only this is displayed. 

Any way to do this? 

Or any suggestions how to do this a better way?

[v-yulgu-msft · Accepted solution]

Hi @BiBra,

Please try below measures:

Average = CALCULATE(AVERAGE('Test Data'[Sales Value]),ALL('Test Data'))

Difference from average = SUM('Test Data'[Sales Value])- [Average]

Best regards,

Yuliana Gu