Forum Discussion
Show average per rows
Hi there, I have this table and I would like to add column that hold Avg Dist per row based on slicer selection And add a flag if Dist > Avg then 1 else 0 I couldn't get the average listed per row...
d_gosbell
Super User
Super User
var _ Avg = calculate(averagex(all(table),distance))
The expression above will ignore the slicer selection, but if you change it to the following it should work the way you want
var _ Avg = calculate(average('Table'[Distance]), ALLSELECTED('Table'))
