how to create table to hold measures in SSAS tabular cube

user_3100444 0
Viewed 250

I want to create an empty table in a SSAS tabular cube (in SSDT, in Visual Studio) to hold all of my cube's measures. In Power BI Desktop, I would do so by creating a 1-column "empty" table in Power Query, loading it into the model, put 1 measure on it, go back into Power Query, delete the empty column, re-load the model, and continue putting measures on the table. But, I don't see an option to do this in SSDT (in Visual Studio) without using a calculated table. Is this possible? If so, how?

ssas-tabular
2 Answers

You don't want to do that. If the table has no columns, you won't be able to see the measures in Visual Studio: Error message

I would create a one column table using the DAX formula ={""} and hide the column in the model and not worry about it.

enter image description here

If you want to name the column and have no rows, you can use this more obscure formula:

=TOPN(0, ROW("Column", ""))
user_35160260

Picking up (and perhaps simplifying) TheRizza's excellent idea - for which thanks - I used this:

enter image description here

You can obviously (I presume) create as many columns as you like. I tried putting a measure in the second column, then removing this from the table calculation formula, and SSAS moves the measure back into the first column (so you don't lose it).

user_6016220
Related