Forum Discussion
DAX STUDIO - Why even use it?
I'd just like some clarification on why this tool is useful. I understand many professional sing its praises so I know it must have a good use but i've never understood what i'd actually use it for. If i'm trying to get a measure to work why wouldn't i just do it in Power BI desktop like i always do? What's the benefit of using dax studio?
I've tried using it but for me at the moment its just another application that's open that does the same thing as PBI Desktop, which i know must be incorrect as so many excellent developers i see online use it and praise it.
Any advice would be appreciated.
Hi Anonymous, I'd start by looking at https://www.sqlbi.com/p/dax-tools-video-course/
Key things I use it for:
- When I can't work out why a visual looks wrong I'll start by using performance analyser in PBI Desktop, copying the query and pasting it into DAX studio. Can then see exactly what filters are on.
- PBI Desktop only supports DAX that returns a single value. There are ways round this with CONCATENATEX and newer To_JSON type stuff but often if you want to see what table is being evaluated in side of a measure DAX Studio is your quickest solution.
- Much more expansive details on the model metrics and query timings.
2 Replies
- bcdobbs
Community Champion
Hi Anonymous, I'd start by looking at https://www.sqlbi.com/p/dax-tools-video-course/
Key things I use it for:
- When I can't work out why a visual looks wrong I'll start by using performance analyser in PBI Desktop, copying the query and pasting it into DAX studio. Can then see exactly what filters are on.
- PBI Desktop only supports DAX that returns a single value. There are ways round this with CONCATENATEX and newer To_JSON type stuff but often if you want to see what table is being evaluated in side of a measure DAX Studio is your quickest solution.
- Much more expansive details on the model metrics and query timings.