Forum Discussion
Measures in a separate table
This is not an uncommon practice. Not sure about the icon, but you could create a Blank query, not add any steps and save it. Then, add measures to that "table". Measures are table inspecific, so they can technically live anywhere.
Hi TonyR the reason that it has a different icon, is that if you only keep your Calculated Measures as visible, and hide all other columns (including your Calculated Columns), when you close and then open your Power BI Desktop Model the icon will then change to show you that the table only has Measures.
This is sometimes a good way to design your Power BI Model, as Greg_Deckler suggested. In creating your model in this manner, the end users know where to find any measures that they require. And the rest of the tables are available to slice and dice their data.
Thx Guavaq
