Create table visual using multiple linked model and only selected measures from each model in SAC

[harpreetchatha]

I need to create table visual by selecting a common dimension like USERID from all the tables and selected measures only from each model. I don't want all the measures from each Models. I have add all model as linked model with JoinType = All Primary Data

Problem: When I add a measures from model 1 I am able to filter to show selected measure from Model 1 and it was easy to filter selected measure only. But, when i tried to add selected Measures from another model(Model 2) then it is removing previously added measure from Model 1. I am not sure what is wrong.

Attached please find screenshot below for reference of what exactly I am looking for as output from input models

Model 1,2,3,0 are the data model having multiple measures on it. and Output table is showing only selected measures from each model:

PS: I am using excel file as data source

Any help is appreciated.

Thanks

Harpreet

[ti_gri]

I guess I found the answer:

In the area of Columns you can select the filter on the dimension Accounts and then select the KPIs you want to see per model.

[ti_gri]

Hi Harpreet

did you find a solution so far for that?