The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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/
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.
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |