Calculation groups ; calculate actuals and budget

[Anonymous]

I've got my calculation group with all time intelligence functions. Works great.

For every "actuals" measure I've also got a '[<measure> budget]'.

Is there a way to dynamically use the 'budget' measure?

Now I'm using a switch statement, but every time there 's a new measure I've to change it.. 

Like this:

SWITCH (TRUE(),
ISSELECTEDMEASURE( [Total result]), [Total result budget] ,
etc..
)

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

Not very clear what you said. But you can try:

x=
SWITCH (
SELECTEDMEASURENAME( ) ,
"Total result budget",...,
"etc",...
)

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer if this video from Guyincube can help

https://www.youtube.com/watch?v=vlnx7QUVYME

or calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/