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 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
1 Reply
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
