Forum Discussion
DAX Help - CrossFilter and LookUp
Community, I am trying to return a difference using multiple tables. I need assistance with DAX for a measure that will return the correct result. I have two tables... Table1 where; Test Index...
As long as the data in the green column is connected via a relationship to Table1/Table2, then the following code should work in a calculated column:
Difference = Table2[Data] - RELATED ( RefData[Ref Data] )
This uses the RELATED function to get the relevant value from the green column.
Anonymous ,
I do not have the ref data as a column and am trying to create a measure for it. Any thoughts on how to replicate the ref data with a measure?
Is the ref data in another table?
Could you connect the tables by the Test Index Number?
I need to pull the ref data from the data column in the by looking at the Ref ID.
So is the ref data calculated? If so, how would you want it to be calculated?
In the example file you posted there's no field called ref data.