Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How can we determine which measures are being used for data visualizations and which are superfluous? I have so many test measures and it's caused my file to be rather bloated.
There is no global way that I am aware of, but you can do it on a visual by visual basis.
You have to repeat this for each visual and slicer, and even check the filters for specific visuals. Measures can be used in visual level slicers.
Unfortunately you cannot multi-select visuals to do this. There was a method here to do this more easily, but apparently it doesn't work due to a change in the PBIX file format.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe measures which are being used in visualizations will be ticked and the unused ones will not be ticked.
So you can differentiate between them
Appreciate your kudos!! Mark my post as solution if this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |