Forum Discussion
Problems combining 2 Tables
Hi guys, I'm having problems combining 2 fact tables and a DAX-measure. Can you please help me to understand what we're doing wrong? This is our datamodel: And when we're making a combinat...
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.
