How to provide average of column data in Card visualisation

[JGH1]

Hello,

I'm trying to include a Card visualisation in my dashboard that simply provides the average of a single column of data (see link below). I haven't come across anything that outlines this. Can someone please help me?

Thanks and Regards,

JH

https://drive.google.com/file/d/12J9sJQ15hyjEGN98TrO_rEW4TAd4oRFc/view?usp=sharing

[v-yiruan-msft · Accepted solution]

Hi @JGH1 ,

If I understand correctly, you would like to get a average of the field [slump]. If yes, you can apply the field [SLUMP] on the visual with the aggregation function "Average" as below screenshot:

Or you can create a measure as below to get it, please find the details in the attachment.

Average of slump = AVERAGE('Sheet1'[SLUMP]) 

If the above one is not what you want, please provide more details(special examples, screenshot etc.) to explain your expected result. Thank you.

Best Regards