With Dax Studio DMV you can easily retrieve and extract information about your Power BI model.
For example:
If you want an extraction of all your measures? Open DAX Studio and at the tab DMV click on TMSCHEMA_MEASURES. Run the SQL select statement…
DAX Studio will then give you an overview of all your measures. Including expressions, format string etc.…
Tip! Change the output option from Grid to Excel Static to export it straight to Excel for further analysis.
You probably know that the ISFILTERED function returns TRUE when the specified table or column is being filtered directly. But did you know that if you add multiple ISFILTEREDs together, ISFILTERED will not return true or false, but will return a number. You can combine this returned number with a switch function to influence your total levels.
Have you ever created a matrix visual, with hierarchy, where your row headers are formatted 𝐛𝐨𝐥𝐝? You can not seem to turn if off, because
Have you ever heard of the “Align” button? It helps you to align visuals, no more precision drag-and-drop…
It also helps to distribute visuals horizontally of vertically over a canvas. This will give an overall alignment of visuals which would make your report so much cleaner.