Forum Discussion
How to list down Measures Per Fact Tables
Hi All
Is there a way to list all the measures that calculates from a given fact table, What I want is something like this and I want to do this for all Worksapces in Power BI, (doing this 1 by 1 is tedious task) do we have any API for this (out of the box) or any workaround to get this
I tried using the INFO.MEASURES() AND INFO.TABLES() function but not quite what I am after
See expample below on what i want for all worksapces (roughly 105)
3 Replies
Hi Anonymous ,
You can refer this -
https://datasturdy.com/dax-query-view-dmvs-for-power-bi-model-using-dax-functions/
I hope it will help you.
Thanks,
Sai Teja
Hi SaiTejaTalasila Thanks, I have tried the INFO () functions, they do not meet my goal, I want all the measures that uses specific Fact table (within a given Worksapce) to calculate the result and then return the name of the table, the definition of the measure etc see above screen shot for what I am after,
I dont think INFO() or DMV's has any solution for this? Thanks
Hi,
It's not possible and you don't have any other option other than manually backtracking every dependency.If you want it for documentation the below method is the easiest one.
Power BI: Exporting Measures & Calculated Columns to Excel
https://www.linkedin.com/pulse/power-bi-exporting-measures-calculated-columns-excel-arno-wakfer?utm_source=share&utm_medium=member_android&utm_campaign=share_via
