topic Re: Where Used in Vertipaq Analyzer in DAX Commands and Tips

Where Used in Vertipaq Analyzer

smart_power — Mon, 10 Jul 2023 08:14:37 GMT

I have installed DAX studio. When I analyzed 'View Metrics' in vertipaq analyzer I am seeing all columns like cardinality, Total size, Data, Dictionary, Hier size etc. But there must be another metric called 'Where Used'. Any idea why it is missing? I installed latest DAX studio.

Thanks,

-Sri

Re: Where Used in Vertipaq Analyzer

johnt75 — Mon, 10 Jul 2023 11:05:12 GMT

I don't think there is that functionality in DAX Studio, but there is in Tabular Editor. You can right-click on a table / column / measure and choose Show Dependencies. That will show everywhere that the element is referenced in code or relationships, but it won't show you whether or not it is used in any visuals.

Re: Where Used in Vertipaq Analyzer

smart_power — Mon, 10 Jul 2023 18:35:01 GMT

Thank you for the reply. Below is the link which i found very helpful and got to know about 'where used' metric. So I see vertipaq analyzer has metric 'where used' and there is nicer way to pull vpax file into powerBI desktop and add 'where used' in filter panel and can exclude all measure that are not used in single shot.

https://exceleratorbi.com.au/which-columns-are-not-used-power-bi-data-model/