Forum Discussion

labuser1235's avatar
labuser1235
Helper 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 some DAX to be written in order to fix this, However, I am unable to figure it out can somone plz help. 

 

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

    • labuser1235's avatar
      labuser1235
      Helper 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.