hello,
the power bi has a-lot of pages
There is a measure which I would like to find out where and in which page it is used?
How is this possible?
thank you
2 Likes
@arkiboys please follow this link
Hello Arkiboys,
Hope you are doing well!
Using DAX Studio, you can use the following commands to get a list of all measures and/or calculated columns in a report. There might be a way to pull if/where they’re being used. I’ll reinstall the program and check.
Pull all measures from PBI schema:
select * from $SYSTEM.TMSCHEMA_MEASURES
Pull all calculated columns (including system columns) from PBI schema:
select * from $SYSTEM.TMSCHEMA_COLUMNS where [Type] = 2
Try and let me know.
Hi! More recently, I have been using Measure Killer from Brunner BI (https://en.brunner.bi/measurekiller). to identify and remove unused
columns and measures in Power BI .
Imke Feldman has retired support for her tool, and you can use the alternative Measure Killer from Brunner BI. (https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/ )
My experience is that the free version works well on local Power BI files; however, you will need to purchase a license to take advantage of more advanced features.
About six months ago Reid Havens interviewed Gregor Burnner and Klaus Folze to showcase.
Learn about this external tool that makes it easy to identify and KILL unused measures and columns from a Power BI dataset (PBIX). Gregor Brunner walks you through how to use this great tool, how it works, and more.
The YouTube Video Introducing the Measure Killer (External Tool) for Power BI! be found at https://www.youtube.com/watch?v=S7EZxOydOf0
More information on the tool including pricing plans and download at the following link:
[Measure Killer | Brunner BI] (https://en.brunner.bi/measurekiller)
Check out their blog post as the following URL:
Good Luck!