How to link 2 views?

Stefano_Mazzocca

My requirement is to have a view where I join Legal Employer Name with Business Unit Name (red) and make the difference between green fields.

I know that Legal Employer and Business Unit are different concepts but weird choices were made in the past and now I need a way to make the difference between these 2.

Thank you

Bhaskar Konar

Hi @Stefano_Mazzocca,

Ideal solution would be creating both measures at respective levels in your warehouse and extend the semantic model to accommodate those into the corresponding Subject Areas. This way you can use those as a readymade columns and just do the subtraction in the report to get the difference between the columns.

As LE & BU are 2 different dimensions, not sure if it is possible to calculate 2 different measure values and their differences on the fly within the Report.

Cheers,

Bhaskar Konar

Hi @Stefano_Mazzocca,

Quick Question: Are you using OTBI or FDI here?

Stefano_Mazzocca

Hi @Bhaskar Konar , it's FDI