Forum Discussion

labuser1235's avatar
labuser1235
Icon for Helper IV rankHelper IV
6 years ago

Same values from different tables

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...
Need Help
Show and Tell
Tips and Tricks
labuser1235's avatar
labuser1235
Icon for Helper IV rankHelper IV
6 years ago

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. 

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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.