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 (58)
RE: List where a column or measure is used in a report
'+1
RE: List where a column or measure is used in a report
Definitely needed so that audits can be done across all reports/tabs to see where specific data elements are used. This is really important as changing field names in the SSAS model will break all reports/tabs that used those fields
I also like the idea of a report that shoes the hierarchy of DAX measures where sub-ordinate DAX measures are used to calculate
RE: List where a column or measure is used in a report
It's really needed!
RE: List where a column or measure is used in a report
Seeing where (in multiple places) a measure is being used would be very useful. But also being able to get an overview of all measures used, and what measures are being used at all in any reports. This helps alot when cleaning up or refactoring, which otherwise becomes extremely time-consuming since each measure could potentially be used SOMEWHERE and you have to go look for it manually...
RE: List where a column or measure is used in a report
Yes please, make it so.
RE: List where a column or measure is used in a report
Yes please!
RE: List where a column or measure is used in a report
PowerBI very slow , want to remove as much column data on initial queries
RE: List where a column or measure is used in a report
Yes please - Much required functionality to better manage content within Power BI solutions.
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.