Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way either in Dax Studio, Power BI Helper or Power BI Desktop to find all columns used in the measures for the whole report.
I have a report file with 10 different tables and 100 attributes. there are 20 measures built.
Is it posssible run an DMVs on DAX Studio to get only the referenced columns in any of those 20 measures.
In understand Define Measure (ALL Tables ) lists all measures with DAX code but i am only interested in getting the depenedent Table and Column names.
thanks
Solved! Go to Solution.
Refer if this can help
https://community.powerbi.com/t5/Desktop/Determine-which-measures-are-used-in-a-report/td-p/526784
https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
https://github.com/didierterrien/Power-BI-assistant
Refer if this can help
https://community.powerbi.com/t5/Desktop/Determine-which-measures-are-used-in-a-report/td-p/526784
https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
https://github.com/didierterrien/Power-BI-assistant
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |