Forum Discussion
Measure Looks To Different Table
Hi v-eachen-msft TCarrasquillo
I've made the relationship active but I'm still having the same problem.
As you can see the Placements measure is looking up to a different table to other measures. I have made a relationship from 'Export Jobs' to the UNION table on username but not getting the required result?
1. Relationship active
2. Edit relationship
3. Placements DAX - looks up to different table
HenryJS ,
It might be helpful to let everyone know what you are expecting from the measure.
From what it looks like, the formula is looking at the Export Actions table, if you want it to look at a different table, like the Export actions - hist.. table then you need to change that in the dax. It would probably help if the 2 tables didn't have names that were so similar.
Your problem could also be the many to many relationship, if there's no way to make the relationship a 1 to many, then you should try to set the direction based on how you want to filter the tables. See my example below...