Forum Discussion
Problems combining 2 Tables
MiKeZZa there is a lot of info here but i dont quite understand what you saying. is it possible to say what you are expecting? is it because the figure is duplicating? its hard to understand because the measure language isn't english is the table1 a calculated table?
loosk like it could be a relationship issue though, maybe a mapping missing or something that needs to be bidirectional vs single?
We're expecting that we get the name of the person with 03: Onbepaalde tijd and as outcome of the measure 0.89. So indeed no duplicating... Now, when we use the DAX-measure, we don't only get 03: Onbepaalde tijd, but also other options....
The measure must sum the same field as we use in picture 1 and divides it by a distinct count... So it must be possible in our opinion....
Table 1 is a handmate table without relationships, it's only to host the dax things, so that they are not deleted when I delete a table in future.
