'Is there a way to filter a table based on criteria from another table in Power BI using DAX?
So, I have two tables, Scores and Accounts.
| ID | Score |
|---|---|
| 1 | 120 |
| 2 | 150 |
| 3 | 100 |
| ID | Account |
|---|---|
| 1 | Account 1 |
| 2 | Account 2 |
| 3 | Account 3 |
I also have 4 measures that calculate the quartile percentile for all of the scores in the Scores table. I was wondering if it was possible to have a measure that concatenates the accounts into one line if their score is, for example, greater than the Quartile 1 measure. For example, if quartile 1 is 110, then I want a measure that would give me "Account 1, Account 2". Is this possible?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|