Average by year but removing a row context

[luizahenriques]

Hello everyone!

I would like to get the average per year but removing the row context ( the column with (a,b,c,d))

Thanks for helping!

[Ashish_Mathur]

Hi,

Assuming % is a measure that you have already written, write this measure

Measure = averagex(all(Data[Text]),{%])

Text is the title of the second column.