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...
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.
Anonymous
The ref data would come from the data column.
The Ref ID is used to establish a comparison.
Maybe we could think of it as we would like to compare Test Index Number 1,2 and 3, vs. Test Index Number 7,8,9
The Run ID is a way to group the Test Index Numbers.