Two dimensions in one column

[rictur]

Hi everybody! 

I'm currently doing a Vizlib Table, which calculates the purchasing volume for every supplier with the concomitant supplier ISO Code (corporation) based on its supplier corporation number.  But some of the suppliers do not have a corporation number but instead only an ISO Code (supplier)  based on their supplier number. 

I have both dimensions defined within the script as "ISO Code Corporation" and "ISO Code Supplier". It is essential to have the corporation ISO Code within the table. Otherwise the table does not aggregate the sum of the purchasing volume. 

Now my question: Is it possible to replace the empty fields of "ISO Code Corporation" with "ISO Code Supplier" where needed and therefore to have two different dimensions in one column? 

Note: All values are Text values, e.g. US, UK, FR, IT etc..

[avinashelite]

Yes, it's possible could share how you wanted to map the codes

[stevejoyce]

Are they in the same table in the data model?  In your load script you can create a new consolidated field, or you can use the same as a calculated dimension, does this work?

If(IsNull([ISO Code Corporation]), [ISO Code Supplier], [ISO Code Corporation]) as [ISO Code]

[rictur]

Hi,

they are not within the same table in the data model. 

I tried it with your approach already @stevejoyce  but it states that isNull requires 1 parameter.