NATURALINNERJOIN

^{Hi YBavré,}

 

^{Can you provide sample data, providing sample data can solve the issue faster.}

 

^{Best Regards,}

^{Gallen Luo}

^{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.}