Hello there, how do you do? Today’s going to be a short one.
What I have for you today is a valuable shortcut which can come in handy whenever you are working with Measures.
As you already might know, Measures are independent of the table in which they are created.
This means that they don’t belong in any particular table and so they can be moved from one table to another and their functionality would be intact.
Why should you sort your Measures?
For orderliness. Imagine having to go through one table or the other looking for a Measure to use in your report simply because you can’t easily locate it. Kind of like this;
What a waste of time. But when you have all Measures in one table, it brings order, makes things easy to find & therefore, saves time. What’s not to like?
Enough talk, how do we do this? Easy;
Now that we have a ‘house’ for these Measures, we can now move them all at once into this new house.
To do this;
Now, all Measures have been moved from their previous location into the new one (DAX),
That’s it! That’s all!
All this in a few steps, in less than what… 3 minutes? (If you’re quick enough it shouldn’t take you more than 2 minutes)
Now, there’s no longer a need for the eyes to travel all over one table or another while looking for where one Measure is placed. All you need to do is to put them in order by creating their own separate space.
Did you find this tip helpful?
You’re very much welcome 🙂