Forum Discussion

pacifist's avatar
pacifist
Icon for Helper II rankHelper II
3 years ago

Master Table -> Details Table: Different values

Hi, 

 

hopefully I will be clear enough. Let's image the following tables (it's actually slightly different)

Master Table:

ACTIVITYACTIVITY_IDCOL_A
CreateDataSource1...
CreateDataSource2...
AddUsersToDataSource98...
AddUsersToDataSource99 

 

Table_CreateDataSource

ACTIVITY_IDDatasourceName
1DS_1
2DS_2
......

 

Table_AddUsers

ACTIVITY_IDUserAdded
98USER_A
99USER_B
......


Now, what I'd like to achieve is in report to have 2 tables:
`Master Table` and below would be `Details Table`. 

When user selects the activity it would fill the `Details Table` with the details depending on the Activity Name. Eg.  I click the `AddUsersToDataSource` | `99` it would load the data (all columns) from `Table_addUsers` table.

Can someone please guide me on what the DAX would look like. I understand I would have to setup the relationships (plenty of them would be inactive as there will be plenty of other activities... I'm more interested if this is achievable with DAX, that it would return the content of the row with different column names.

Thank you

 

No RepliesBe the first to reply