NATURALINNERJOIN

^{Hi YBavré ,}

^{NATURALINNERJOIN DAX Function:Joins the Left table with right table using the Inner Join semantics.}

^{Based on your description, I think you can use the union function and then use the count function to count each row in the table:}

Common = UNION（_Table_SE_Only, _Table_ORG_Only）

Count = CALCULATE(COUNT('Common '[Enterprise_Nbr]),FILTER(ALL('Common '), 'Common '[Enterprise_Nbr]= MAX('Common '[Enterprise_Nbr])))

NATURALINNERJOIN - Microsoft Power BI Community

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}