Forum Discussion
Keep Avg when Filters applied
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 t...
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/1447523/jump-to/first-unread-message