Hi @AntrikshSharma - I wish I could I avoid MAXX altogether but I don’t think I can. The table that I am supplying MAXX to has just 3 columns, AccountNumber, Zip Code and Sales. Zip code is used to join the table with the store list look up table so that when I filter by an account in store list, the MAXX table will be filtered to only the zip codes where that account operates. However, I need the maximum sales by account as an aggregate of these zip codes, not the maximum zip code, so I use the following expression to calculate the maximum sales by any account, excluding the account in scope, in the zip codes where the account in scope has stores.
var _SelectedAccount = if(HASONEVALUE(StoreList[Account_Number]),
var _MaxVol =
"Max Vol", calculate(sum(Market[Sales_Volume]),
Please let me know if you have a suggestion for optimization