Average of a column

[Anonymous]

Hi, 

Im trying to get a coloumn to show the average linear sale density for the all the values in the row "linear sales density" to use as a comparison. I am expecting the value to be the same in each row how ever getting a different figure for each row. I cant share data as its commercially sensitive however. The linear sales density is a measure that takes the average weekly sales stored in an excel backsheet Data{AWS] and multiplies it by the width spt{PlanogramWidth]

[Zubair_Muhammad]

@Anonymous 

Something like this ...may be

Average LSD =
AVERAGEX ( ALLSELECTED ( TableName[RowFieldinyourVisual] ), [LSD] )

[Anonymous]

Hi thank you for the prompt response and suggestion

however that still produces different values on each row.

Thanks again.

[v-lili6-msft]

hi, @Anonymous 

You need to use AVERAGEX and “all” functions to create a new measure

and for your requirement, it needs detailed data structure, if possible, please use virtual data or create a simple sample pbix file for us to have a test.

Best Regards,

Lin