#PowerBI – update your measures without the formula bar

The introduction of the DAX query view (official blogpost) and the new INFO DAX functions (official blogpost) gives us some very possibilities to update our measures without using the formula bar.

We can for instance create a query that shows all the measures that has an error message like this

EVALUATE	VAR _X =INFO.MEASURES()	RETURN		FILTER(_X, [ErrorMessage]<>"")

This will extract all my measures in the open power bi file that contains an error message.

In this case I have a measure that contains an error message telling me that I can’t use a True/False expression to filter a table. Normally you would probably search for the measure and the field list and modify via the formula bar but there is another way and will make it possible to test it before you update it.

Let me show you how 😀

The INFO.Measures() also returns the expression for the measure

Select the expression and press CTRL+C to copy the expression

Then go to the DAX query and type in DEFINE followed by a line break and then use intellisense to find the Measure and paste the copied expression – this look something like this

As soon as you start to modify the expression of the measure the text “Update model: Overwriting measure” will appear

And if you want to test it before you hit the update model “button” – you can add an EVALUATE statement and see if the measure works as intended.

When you click to update – you will get a warning that tells you that there is no way to Undo it – so be sure 🙂

About the Author

Hey – I blog about Power BI and other elements in the Power Platform and do talks in the Community

References

Svensen, E. (2024). ‘#PowerBI – update your measures without the formula bar’, Available at: https://eriksvensen.wordpress.com/2024/03/06/powerbi-update-your-measures-without-the-formula-bar/ [Accessed: 29th March 2024].

Share this on...

Rate this Post:

Share:

Topics:

Power BI