• Antriksh Sharma

Sneak Peak of a code inside a DAX Measure

Updated: Apr 8

Wouldn’t it be awesome if we could sneak peak the code of a measure A when we are writing a different measure B and calling measure A inside B? going back and checking would mean exiting the current measure B then looking at the code of A and then you have to remember what the code is and also make a decision to call it or not basis the content? worry not Tabular Editor has something to offer:

Open your PBI file:

Click on external tools and open Tabular Editor:

Navigate to Advanced Scripting section and enter this code and click on run button:

=foreach (var Measure in Model.AllMeasures){ Measure.Description = Measure.Expression; }

it is a regular C# foreach loop that iterates over each measures in the AllMeasures collection(.net object/class) and then for each measure updates its description with its code.

And then in the diagram view you will be able to view the DAX code in the description.

That was just techy stuff, fun part starts now:

Let’s say you are really deep into the code and now you have to call a measure but you just don’t know how it will interact with the rest of the code, you can simply start writing and the description tooltip will pop up beside.

28 views0 comments

Recent Posts

See All

Tabular Editor 3 Course

TE3 is the ultimate development tool for creating Tabular Model and recently I got an opportunity to make a full fledged course on it for Enterprise DNA. Here is a post about that and how you can secu