Related: pulling in a column into a Fact table from a look up table

[hxkresl]

I am trying to bring a copy of the Application Name into the mc_alerts table, by creating a Column using RELATED.  That does not work.

Reason: I need to show relationship between lineofbusiness and applications on a pivot table 

How to do it?   for every alert, there is an applciation affected, so it should be possible. 

[v-huizhn-msft]

Hi @hxkresl,

In mc_mc_alert_mc_applicationset table, you can create a calculated column using RELATED function.

AppName=RELATED(mc_Applications[ApplicationName])

Then create a calculated column in mc_alerts table like the formula. Please replace the [A] and [B] columns as your actual related table.

AppName1= CALCULATE(FIRSTNONBLANK(mc_mc_alert_mc_applicationset[AppName],1),USERELATIONSHIP(mc_alerts[A],mc_mc_alert_mc_applicationset[B]))

Best Regards,
Angelia