How to make some tables not showing up when making metrics

[mazwro]

I have two tables: A an B.

In Power Query, I did a merge between those two and imported two columns which I need, so I don't need to create relationships. Now I have tables like this, for several brands, so ther eis 5x the following setup

A: ID, date, ColC, ColD, NetSale, COGS

B: ID, ColE, ColF, NEtSale, COGS.

When I create metrics and query net sale, I see from available columns both table A and B. How can I do it that Table B does not show at all in the lookup?

[audreygerred · Accepted solution]

Hi! In Power Query you merged B into A and do not want B to show up in Power BI Desktop, correct? If so, go into Power Query and right click on your query for B and uncheck Enable load. This will stop that table from showing up in desktop since it not needed there.

[mazwro]

Amazing! thanks!

[audreygerred]

No problem!