Same values from different tables

[labuser1235]

Hi All,

I am working on Contoso sample. When I tried to show values from two different tables irrespective of relation it always shows same values in enire row. I understand  that there should be some DAX to be written in order to fix this, However, I am unable to figure it out can somone plz help. 

[amitchandak]

Either join is not correct or all(table) has been used in the calculation. Please share calculation

[labuser1235]

@amitchandak I can't join those tables as there are no common fields. I haven't used any DAX expression to get the count of Employee. I have just added the Employee Count from Stores Tables in values using the matrix table.

Please check the screenshot for reference as it shows the relation. 

[labuser1235]

@amitchandak  ContonsoPowerBISample.PBIX 

Sharing the PBIX file I am working on. Please check.

[amitchandak]

Product and store have no relation, they are just reference tables for sales.   Now what is the number you are expecting this query to display for employee.