Kunaal Bhagani on 09 Jul 2020 01:59:18
This suggestion is coming from a different perspective whereby I am building a complex whatif scenario with parameters and the modelling logic is separate to the visualization. this my case we had to build a headcount rollforward and because DAX doesn't support circular dependency i.e referring to a dependent measure but for a different year e.g. if we have calculated the value of prior year forecast and i want to use it in next years forecast, we have to set up multiple measures for each year to achieve the calculation.
I understand we set up variables only in measures but the limitation of measures is that they have to return a scalar value. This makes is difficult when building complex measures with variables to have to define the same variable in different measures.
It would be great there was a way to set up measures that return virtual tables or a way that if we set up a measure and put public in front of a variable then that variable in the measure is automatically available to any other measure and a short cut to it can be seen in a public variables folder or something.