topic Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation in DAX Commands and Tips

Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

Anonymous — Thu, 10 Feb 2022 12:52:09 GMT

I have en existing measure called [O_VOL_ACT] and from this measure I derived several other measures like previous year and many others (Time Intelligent)..:
[O_VOL_ACT]

[0_VOL_ACT_PYTD] = Previous Year To Date

[O_VOL_ACT_PY] = Previous Year

[O_VOL_ACT_PY_DEV] = Deviation between Previous- Actual Year

[O_VOL_ACT_PY_DOW] = Previous Year Day of Week

[O_VOL_ACT_YTD] = Actual Year To Date

......

Now, what I try to archiv is, that I can compile the measurename by doint something like concatenate the base measure [O_VOL_ACT] with any suffix of the derived measures like _PY.

As a Result I want to get something like [O_VOL_ACT_PY] which I could use for example in a matrix.

Based on outside criteria (IF/ELSE) suffix _PY or _PY_DOW must come to action.

Of course, concatenate doesn't work! Any other ideas how to solve this issue ?

Regards

Alex

Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

Anonymous — Thu, 10 Feb 2022 13:17:23 GMT

Hey,

A bit unclear of the reason for such measure but perhaps Calculated Groups could work
e.g. final solution would give user a filter to choose what you they want to see PYTD, PY, etc. and depending on that you would give result
Calculated groups could have two measures, one to show text: using SWITCH, if SELECTEDMEASURE = PY then "PY" and etc.
and another to show correct value.
https://community.powerbi.com/t5/Desktop/using-calculation-item-in-another-calculation-items-Time/m-p/2320060

https://community.powerbi.com/t5/Desktop/Extract-name-calculation-item-from-calculation-group/m-p/1650272#M661273

Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

tamerj1 — Thu, 10 Feb 2022 13:23:12 GMT

Hi Anonymous
Whwn you say "Based on outside criteria (IF/ELSE) suffix _PY or _PY_DOW must come to action." what do you mean by "outside"?

Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

Anonymous — Thu, 10 Feb 2022 13:37:23 GMT

The requirement is to be able to switch the previous time selection between "previous year" and "previous year day of week".
At the end the user should be able to tick a switch and see eighter the upper- or lower variant of comparision.

Calc-Group wont work.

Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

Anonymous — Thu, 10 Feb 2022 15:56:23 GMT

You can achieve that with calculated groups.
I would probably do calculated groups to select 2nd measure to compare with actual and then use visual Column Chart with Relative Variance

So in this proposed solution you have actual added in visual and then another measure that changes value based on users selection.

Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

v-angzheng-msft — Wed, 16 Feb 2022 02:21:22 GMT

Hi, Anonymous

The requirement is to be able to switch the previous time selection between "previous year" and "previous year day of week".
At the end the user should be able to tick a switch and see eighter the upper- or lower variant of comparision.

Based on what I got above, the calculation group would be a good choice.

e.g.

Refer:

Introducing Calculation Groups

You can also use the Switch function with slicers
e.g.

Switch( True(), SelectedValue="PY",[O_VOL_ACT_PY], SelectedValue="PYTD",[0_VOL_ACT_PYTD] )

Best Regards,
Community Support Team _ Zeon Zheng

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

Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

Anonymous — Mon, 21 Feb 2022 14:27:41 GMT

I could solve my problem with Calculation Groups, so you where right 😉 !!
Thanks for the hint.

I created an overview pic which more or less should explain my created solution.

Re: Compile MeasureName by name parts and use this dynamicaly measure(name) for calculation

Anonymous — Mon, 21 Feb 2022 14:30:19 GMT

I already solved my issue. But your solution with the "Switch" and "SelectedValue" is great. Will add that to my list of (best) code snippets :-).
Thanks