Skip to main content

Power BI

New

Measures and or Public Variables for Virtual table

Vote (1) Share
Kunaal Bhagani's profile image

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.