Dave Gugg on 17 Dec 2016 06:00:28
It can be unwieldy to manage measures and columns, especially when custom measures and columns are built on top of other measures and columns. It would be helpful to have a [Where Used] option to provide a list of visuals and/or columns/measures where a particular column is used. That way you can delete unneeded measures/columns without worrying about breaking everything.
- Comments (60)
RE: List where a column or measure is used in a report
Please, yes! This functionality is really required, it is almost impossible to discern unused formula and as such they are left in the model which is very messy. Thanks.
RE: List where a column or measure is used in a report
Yes, this function like the trace dependencies in Excel would be very helpfull.
RE: List where a column or measure is used in a report
Looking forward to it, still, it is 2019 now...
RE: List where a column or measure is used in a report
I have been asked to optimize a report that was created by someone who has moved on from this team. Something like this would be an enormous help in figuring out which columns I can safely remove. Without it, the work is very manual and extremely time-consuming.
RE: List where a column or measure is used in a report
Sure would be helpful. Or, at minimum, some icon or highlighting on columns and measures to indicate they're used elsewhere - either in other measures/columns or in visuals. When you select a visual, it shows what columns/measures are used. I really hoped I could just 'select all' and see all columns in use. But it just deselects everything in that column view when you select more than one visual.
I have very low hopes of this being addressed, given how old this idea is.
RE: List where a column or measure is used in a report
This is so relevant to a project I am working on, please consider it!
RE: List where a column or measure is used in a report
Yes need that at the moment...
RE: List where a column or measure is used in a report
100% needed.
RE: List where a column or measure is used in a report
It would also be nice to have Search functionality within PowerBI, so you can search in all the Dax where measures/etc. are used, so you know all the places where you need to adjust something
RE: List where a column or measure is used in a report
Would make 'cleaning up the model' a whole lot easier..