So I have a app table that looks like this
| App Name | Index | Dataset |
| Facebook | 1 | fb |
| Twitter | 2 | tw |
| Gmail | 3 | gm |
then I have three datasets
users
| user name | email | address | zip | emp id |
| bob | bob@gmail | bob st. NYC | 40203 | 1243 |
| steve | steve@gmail | steve st. NYC | 59420 | 0230 |
| | | | | |
twitter security
| user name | security page | access date |
| bob | homepage | 1/1/1200 |
| bob | profile | 1/2/1200 |
| bob | FAQ | 1/2/1200 |
facebook security
| user name | security page | date |
| bob | profile | 1/2/1200 |
| bob | FAQ | 1/2/1200 |
I then have a table visual which has the app name as the first column. I am trying to create switch statement of some sort to return the second column which is security page. The desired output looks like when I filter on bob:
| name | security |
| Facebook | Homepage |
| Facebook | FAQ |
| Twitter | Homepage |
| Twitter | Profile |
| Gmail | No Security |
I have built the following to just test the first table... however it is only returning the max selection. My measure looks like
SECURITY TEST =
IF(HASONEVALUE('App Table'[AppName]),
SWITCH(TRUE(),
'App Table'[Appname] = "Facebook", CALCULATE(IF(MAX('Facebook'[BaseUserName]) = [selectedID], max('Facebook'[Security]) ,0),FILTER('Facebook', 'FacebookID = [selectedID] ))))
BUT ^ this returns only one value from the Facebook security column and not every value. Please help! I cannot create a column in my model on the transactional data.
