I have tried multiple ways to return multiple values using DAX without success. These are the things I've tried SelectColumns, LookupValue and Filter. I do not get the correct results.
The following are the table:
| Issue No | Description | Assignee_Type | Assignee_ID |
| 1 | Investigate rate hikes | role | 1234567890 |
| 2 | Enrollment quotes are down | user | 99993331 |
| 3 | Adopt DriveWise program | company | 443264143 |
| 4 | Enrollment quotes are down | user | 99993332 |
| User_ID | First Name | Last Name | Company_ID | Role_ID |
| 99993331 | Tom | Jones | 100 | 1234567890 |
| 99993332 | Vincent | Price | 200 | 1234567890 |
| 99993333 | John | Walker | | 1122334455 |
| Company_ID | Company_Name |
| 443264141 | Allstate |
| 443264142 | State Farm |
| 443264143 | Progressive |
| Role_ID | Role_Name |
| 1234567890 | Insurance Agent |
| 1234567891 | Insurance Broker |
| 1122334455 | Administration Assistant |
I want to report all of the Companies tied to the Issues.
Issue #1 should report Allstate and State Farm.
Issue # 2 should return only State Farm.
I've been able to use DAX to return one value but not two. Can you please give me some guidance? Thank you in advance.
