r wa
1 TopicNATURALINNERJOIN
Hi, I have created two tables: _Table_SE_Only = CALCULATETABLE(VALUES(ENHANCED_CKI_CUSTOMER[Enterprise_Nbr]), filter(ENHANCED_CKI_CUSTOMER,ENHANCED_CKI_CUSTOMER[Cust_Segm] = {"Independent"})) and _Table_ORG_Only = CALCULATETABLE(VALUES(ENHANCED_CKI_CUSTOMER[Enterprise_Nbr]), FILTER(ENHANCED_CKI_CUSTOMER,ENHANCED_CKI_CUSTOMER[Cust_Segm] IN {"IVSE", "VSE", "SME", "Mid-Market", "Large Enter"})) So I now have two tables with 1 column, being "Enterprise_Nbr" in both tables I want to count the number of common "Enterprise_Nbr" from both tables. So I used Common = NATURALINNERJOIN(_Table_SE_Only, _Table_ORG_Only) But I get the error message NATURALINNERJOIN requires at least one common join column I don't understand what I'm doing wrong. Can anyone help? Thanks. Or is there another way to get the result I need?864Views0likes3Comments