Forum Discussion

lawada's avatar
lawada
Helper III
5 years ago

data model connection error

i have three tables connected to each other as shown in the image below: to explain the model:  (Query) table shows the order id with the laundry branch name and other orders details (like us...
Need Help
Pragati11's avatar
Pragati11
Super User
5 years ago

Hi lawada ,

 

Out of your 3 tables, from which tables are you moving the columns to this visual?

Is there any summarisation on the column when moving to visual?

 

Thanks,

Pragati

  • lawada's avatar
    lawada
    Helper III
    5 years ago

    i want to use laundry_branch_id from (laundryBranch ID) table, orde id from (Query) table and commission_ percentage from (laundries contracts).  all the coloumns should be not summarized

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      5 years ago

      Do you get the expected result if you summarize the percentage column?  One of them need to be summarized (or have a measure doing so) for that to work.

      Pat

      • lawada's avatar
        lawada
        Helper III
        5 years ago

        summarizing the percentage column will result in different values which wont be correct . is there a way to solve this without having to summrize the percentage coloumn