Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |