How to identify all measures that refer to a fact table

[Anonymous]

Hello,

In our data model we plan on changing the grain of several fact tables (going down a level in the grain). In order to regression test after the change, I would like to check that all the measures still return the same results at the original grain. To do that, I need to identify all measures that refer to the fact tables.

Does anyone know of a way to list all measures that refer to a table? If only there was a right-click "Show Dependent Measures" on the table object!

[Anonymous · Accepted solution]

I've found found this forum post which looks useful

Solved: How to check which fields and measures are dependa... - Microsoft Power BI Community

[Greg_Deckler]

@Anonymous Maybe something like @ImkeF's Power BI Cleanser external tool? I think Bravo also might do that as well. Probably some external tool for it.