Inactive relationship

[jsteffe]

Hello,

I get the model below :

As there is one relationship between country and customer, the relationship between country and employees is not active.

So how can I get a table with total of employees and total of customers per country ?

Thanks

[amitchandak · Accepted solution]

@jsteffe , country should join to order details.

Or do you need to have merged tables -  Customer+country

and Employee and Country

[VahidDM · Accepted solution]

@jsteffe 

In addition to @amitchandak reply, you can use USERELATIONSHIP code.

https://www.sqlbi.com/articles/using-userelationship-in-dax/

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

[jsteffe]

I tried his formula and it works :

nb_employee_per_country = CALCULATE(count(Employee[EmployeeID]),USERELATIONSHIP(Countries[name],Employee[Country]))

Thanks

[amitchandak · Accepted solution]

@jsteffe , country should join to order details.

Or do you need to have merged tables -  Customer+country

and Employee and Country

[jsteffe]

Merged table are a solution. Thanks