Combine 2 Measures into 1 Column

[BICrazy]

Hi,

I have 2 measures that were each created from separate tables which are labelled Sales Conversion Rate as per the screenshot attached. I'd prefer to display both of these measures as one column for the dashboard.  

Basically if the one column is blank then it needs to use the value from the next column.  Unfortunately I cannot create a custom column in this instance because I'm not using calculated columns, but measures instead.

Kind regards

[Anonymous · Accepted solution]

Hi,

I think an IF Statement would do.

New_Column:= IF(Table[Sales_Conversion1]<>BLANK(),Table[Sales_Conversion1],Table[Sales_Conversion2])

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂

[BICrazy]

@Anonymous  - Hi, I've changed the measures to calculated columns. However, the IF statement won't work in this situation because the calculated columns are in separate tables and I cant create a relationship between the 2 tables because none of them contain unique values.