Return the list from a text column based on filter condition on another one

[deedeedudu]

Hi,

I'm trying to create a measure to get a list in the column titled "Enterprise" based on another column "Alert_Breach" for values that has only "Alert"

Example

Enterprise	Alert_Breach
AAA
BBB	Alert
CCC	Alert

I should get the list as "BBB" and "CCC" so that when i add the measure in card i get BBB and CCC

[mahoneypat · Accepted solution]

Please try this measure expression, replacing Alerts with your actual table name.

AlertList =
CONCATENATEX(
CALCULATETABLE(
DISTINCT( Alerts[Enterprise] ),
Alerts[Alert_Breach] = "Alert"
),
Alerts[Enterprise],
", "
)

Pat