Anderson Oliveira on 14 Oct 2021 20:50:20
I use tens of similar measures that share most of their code.
They all calculate results based on a intermediate FILTER statement, that returns a table to a var.
Whenever I need to maintain the code, I need to copy & paste the same new code to all measures.
I am also worrried about performance (repeatedly executing the same code for all measures).
What if I could write the FILTER dax code only once and return this table, so that all measures could use it?
I would be like a global var containing a table, or a measure that returns a table.