topic Re: Is Measure Branching a good idea for report performance in DAX Commands and Tips

Is Measure Branching a good idea for report performance

Anonymous — Wed, 30 Jun 2021 20:09:49 GMT

I have avoided using referencing measures inside other measures (Measure branching) because I heard from somewhere that was a bad idea (I don't remember where). But there seems to be a few including Enterprise DNA who think it is a good idea. I couldn't anything official from Microsoft that says this a good for performance. I plan on installing DAX Studio when my IT department adds it to the software whitelist so I can test it myself. But I was hoping to get confirmation from more sources that measure branching is a good idea before using it.

Re: Is Measure Branching a good idea for report performance

Fowmy — Wed, 30 Jun 2021 20:34:56 GMT

Anonymous

It depends 🙂

When you create a measure, it is wrapped in a CALCULATE function. It depends where you want to use it. If you do not need a context transition to happen for example in a row context then do not use measure there. However, Measure Branching, in general, doesn't affect the performance, it will is the same. I heard it from Marco Russo as well.

Re: Is Measure Branching a good idea for report performance

Jihwan_Kim — Thu, 01 Jul 2021 03:29:47 GMT

In my opinion, it is not a good idea when it references measures ( or references measures that already referenced other measures) that have ALLSELECTED function as a CALCULATE modifier (inside the CALCULATE function).

I only know the above case that I need to double-check and audit the result of the measure every time.

Other than the above, I still need to learn and study whether there are any other cases that make Measure Branching not a good idea.

Re: Is Measure Branching a good idea for report performance

Anonymous — Thu, 01 Jul 2021 10:34:51 GMT

So if I use CALCULATE then don't use that measure in another measure? Do you know where you heard it from Marco Russo? I am only 7 chapters in The Definitive Guide to DAX 2nd edition. I didn't see anything specific for measure branching in the contents.

Re: Is Measure Branching a good idea for report performance

Fowmy — Thu, 01 Jul 2021 13:47:45 GMT

Anonymous

No, I did not mean that way. You can use a measure inside another measure, all I meant was a measure is always wrapped within a calculate function, so when you use it inside another calculation, it will create context transition. I just stressed this point. So, you can use a measure inside another as long as you are aware of the context.

The following video explains the nested calculate usage: marcorusso

https://www.youtube.com/watch?v=hZd9EgUR7Do&t=3580s