web
You’re offline. This is a read only version of the page.
close
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.