Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.