Keep Avg when Filters applied

[KariMac10]

Hey Hoping this is possible, I am wanting to keep the Brix Avg for the ISO week when I filter by Orchard: 

This is my current set up, which I then filter by Variety and Orchard, but the avg disappears, I would like to create a option to keep the Avg and select the Orchards I want to compare against the Avg. 

Thanks 

[danextian]

Hi @KariMac10 ,

If you want your aggregation to  be by a specific column, you would need something like

My measure =
CALCULATE ( AVERAGE ( data[olumn] ), ALLEXCEPT ( data, data[week column] ) )

The measure above returns the same average for  particular week regardless of the Orchard Name. That's just the general idea. If that that suffice, please provide a usable sample data and your expected result from that data. Please refer to this sticky post: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...