Forum Discussion
Helper IIIjoin a virtual table with an imported table
What you have there is a measure which returns a scalar value. The virtual table is only relevant to the calculation and is not a physical table in the model. So you can't create relationships.
You need to create a new physical table using the code you have for the virtual table in a new table (under "Modeling" in the ribbon).
Community ChampionWhat you have there is a measure which returns a scalar value. The virtual table is only relevant to the calculation and is not a physical table in the model. So you can't create relationships.
You need to create a new physical table using the code you have for the virtual table in a new table (under "Modeling" in the ribbon).
reynaldo_malaveThanks PaulDBrown, this is the answer I was looking for. I did create a calculated table but its fixed table, so no slicing and dicing since it only returns totals.