Skip to main content

Power BI

Needs Votes

Role playing dimensions SSAS Tabular

Vote (8) Share
Hilbert's profile image

Hilbert on 30 Sep 2017 02:12:07

Hi,

Don't want to use a Dax formula in my calculations if i want to use my date table multiple times. Could you add the Role playing dimensions to SSAS tabular like this is possible with a SSAS SSAS Multidimensional Cube.

Comments (2)
Hilbert's profile image Profile Picture

Brett Gerhardi on 14 Oct 2021 16:37:39

RE: Role playing dimensions SSAS Tabular

calculated tables still need a lot of configuring. all properties - Format strings, calculated columns etc are not copied, it only copies the raw partition columns.

There is a solution here and something with less boiler plate code would be better https://martinschoombee.com/2020/06/24/a-user-friendly-way-to-deal-with-role-playing-dimensions-in-power-bi/

Potentially could use Calculation Groups to extend this idea however it means that we would end up with one calculation group per table that needed it which would extend the cube complexity for end users. Better to build something in as a first class citizen.

Hilbert's profile image Profile Picture

Power BI User on 05 Jul 2020 23:20:38

RE: Role playing dimensions SSAS Tabular

You can create a calculated table based on your initial dimension.