Set analysis not working

[ritumishra01]

=if(not isnull(prj_number) and len(prj_number)>1,prj_Status,
if(((not IsNull(dmnd_number)) and len(dmnd_number)>1) or (isnull(prj_number) and (len(prj_number)<1)),dmnd_status,
if(not isnull (idea_status),idea_status)))

while i am giving this as measure i could see prj_status and dmnd_status but i could not see idea status its showing null

[joaopaulo_delco]

Hi @ritumishra01 

I recommend you do it on load script creating a new dimension for this purpose.

[ritumishra01]

ually these three fields are coming from three different table and if i join these tables it is giving me error .not sure what approach can be used here