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.
What I would do to get the result that you showed in the screenshot (including the measure icon as well) is the following:
1. I would create a new blank table and name it Measures Table that will create a table with a blank column names Column 1.
2. I would create my first measure in the table from step 1.
3. I would then delete the Column 1 that was created automatically when I create the table.
4. I would then create any other measures I need to create.
PowerBI will automatically understand that you have create a table for your measures and will update the icon from a table icon to a measures icon.
I hope that helped someone, I would appreciate it if you'd leave me a like 😁😁😁
Hi , i have the same issue and search on internet gave me this topic, so couple years later a reply 🙂
anyways, when i create an empty table, it needs a column. And i cant delete that column after i have added a measurement to that same table. But i do remember, from PBI courses i took, that we created empty tables and added measurements to it. I just cant remember how it worked ...
You can hide the column and it will do
(or maybe you could do that)
