Forum Discussion
Dax Studio for Documentation
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
I never tried that
Try
SELECT DISTINCT([OBJECT_TYPE]), [OBJECT], [EXPRESSION]
from
$SYSTEM.DISCOVER_CALC_DEPENDENCY
Best
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,
This doesnt work. Its just givine me list of only calculated columns, measures & tables. In your query-
from
this is taking Calc_Dependency only.
I want list of all columns, measures and tables.
- EVALUATEINFO.VIEW.COLUMNS()EVALUATEINFO.VIEW.MEASURES()EVALUATEINFO.VIEW.TABLES()EVALUATEINFO.VIEW.RELATIONSHIPS()these work on DAX query view in PBI Desktop or in DAX STudio connected to the semantic model
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your threadconsider 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