Forum Discussion
Dax Studio for Documentation
- 1 year ago
launch the following query in DAX studio after setting the output to a static Excel file that will be saved wherever you want at the end of the query execution:
SELECT DISTINCT([OBJECT_TYPE]), [OBJECT], [EXPRESSION]
from
$SYSTEM.DISCOVER_CALC_DEPENDENCY
WHERE
[OBJECT_TYPE]='CALC_COLUMN' OR [OBJECT_TYPE]='MEASURE' OR [OBJECT_TYPE]='CALC_TABLE'
Once the query is launched, DAX studio allows you to export the result to an Excel fileBy the way you can also use Info DAX functions in Power BI Desktop as an alternative
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi,
Thanks for your reply. This query gives me list of columns and tables, but it doesnt include measures in the same list.
I am afraid there is no specific way to obtain what you want in a single list