Forum Discussion
Dynamically filter a table to perform benchmarking
Hi all. I've been stewing on this all day and can't figure it out. I have two tables: 1) A list of salesperson names and office locations: Salesperson in Table 1 has an established one:ma...
Anonymous , try measure like
Measure =
var _office = Summarize(allselected(Table1), Table1[Office])
var _Region = Summarize(allselected(Table1), Table1[Region])
return
calculate(averageX(Values(Table1[Salesperson]), calculate(Sum(Table2[Sale]))), filter(all(Table1),Table1[Office] in _office && Table1[Region] in _Region))