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...
Yes, this looks very great! In my small example it works. I'll give it later today a try in my more complex model, but I'm hopeful... I'll come back to post my progress!
But can somebody explain me what happens here; why hasonevalue?
Tried to use it in our own (more complex) model, but we now have problems with multiple facts in 1 fact table.... This gives the situation that the hasonevalue gives FALSE (I think) and makes that he chooses the wrong side of the if
CALCULATE ( SUM ( 'edm uitbetaaldefte'[uitbetaaldefte] ) )
So this is not good...
Can somebody tell us why this HASONEVALUE is in the code? When we understand this better maybe we can arrange a solution....