Measure Looks To Different Table

[HenryJS]

Hi all,

I have created a measure 'Placements' which looks to a different table to all other measures/columns.

It doesn't show the data correctly it only shows the total on every row?

I have created a data connection to UserName as per image 2

please advise

1. Measure

2. Data Relationship

[v-eachen-msft]

Hi @HenryJS ,

You could set the relationship to be active or use USERELATIONSHIP() function.

[HenryJS]

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

[TCarrasquillo]

@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...

[TCarrasquillo]

Your problem might be that the relationships aren't active, both the lines between your tables are dotted/dashed, meaning inactive.

You might need to figure out how to make at least one of them active.