Possible to check for blanks in another table as part of IF(ISBLANK statement?

[Anonymous]

I need to check for blanks in another table entirely from my data source that I have a one to many relationship with in my model.

Server Data Quality? = IF(ISBLANK('snow cmdb_ci_server'[u_appliance])||ISBLANK('snow cmdb_ci_server'[u_backup])||ISBLANK('snow cmdb_ci_server'[cpu_core_count])||ISBLANK('snow cmdb_ci_server'[cpu_count])||ISBLANK('snow cmdb_ci_server'[u_dmz])||ISBLANK('snow cmdb_ci_server'[dns_domain])||ISBLANK('snow cmdb_ci_server'[dv_u_environment])||ISBLANK('snow cmdb_ci_server'[host_name])||ISBLANK('snow cmdb_ci_server'[dv_install_status])||ISBLANK('snow cmdb_ci_server'[ip_address])||ISBLANK('snow cmdb_ci_server'[dv_location])||ISBLANK('snow cmdb_ci_server'[dv_manufacturer])||ISBLANK('snow cmdb_ci_server'[dv_model_id])||ISBLANK('snow cmdb_ci_server'[name])||ISBLANK('snow cmdb_ci_server'[os])||ISBLANK('snow cmdb_ci_server'[dv_u_operations_support_provider])||ISBLANK('snow cmdb_ci_server'[os_version])||ISBLANK('snow cmdb_ci_server'[dv_supported_by])||ISBLANK('snow cmdb_ci_server'[dv_support_group]),"BAD","GOOD")

I have another table from my data source called snow_u_report_bizapp_app_server with a column called dv_u_application in which I also need to check is blank for my calculated column on my server table.

Is this even feasible?

Any more logical ways to go about this? 

In case you can't tell I'm relatively new to Power BI.

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous , if there is relation between two table you need bring column in one the way and check for blank

New column in Table 1

1-m 

var _1 = related(Table2[Col1] )

M-1 relationship 

var _1 = maxx(relatedtable(Table2), [Col])

No relation just using join 

var _1 = maxx(filter(Table2, Table2[id] = Table1[id])  , Table2[Col])

Check if _1 isblank 

isblank(_1)