Find where a measure is used

Power BI

Power BI Desktop does not list the visuals that use a measure, and lineage in the service stops at whole reports. Reading the project is the way to find them.

Power BI Desktop has no list

Power BI Desktop does not show which visuals use a measure. Answers accepted as the solution on the forum, from 2018 and 2020, say there is no built-in way to tell.

Source: Determine which measures are used in a report, How to find Impact Analysis that measure/dimension is used in which report?.

What the service shows

Lineage view shows how dashboards, reports, semantic models, dataflows and data sources connect. It needs a Pro license and the Admin, Member or Contributor role.

Impact analysis counts the reports and dashboards that a change to a semantic model might affect, and needs write permission on the model.

Both work on whole items. Neither says which measures a visual uses.

Source: Data lineage, Semantic model impact analysis.

Check a project in your browser

The Power BI Report Doctor reads a PBIP folder or .zip and lists the file and line to fix. Nothing is uploaded.

Open the project in Power BI Studio. Calculations lists each measure with the number of visuals that use it, directly or through other measures. Click one and it says how many visuals on how many pages use it, or that no visual does. It runs in your browser, so it works on a Mac with nothing installed.

Other guides

Sources

What you put into the tools never leaves your browser. We count page views and keep them for 90 days. Accept and we also remember this browser, so a return visit is not counted as new. Privacy policy