Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Creating a Data Comparison Table From Two Different Datasets

Hi everyone,    I have been asked to create a data comparison table whereas I ran against a problem I can't manage to solve. The main purpose is to see the difference between the results of the lab...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

I would change the model. Make the relationship from Calendar to Lab Analysis 1-to-many and single direction,  make the relationship from Digester Reference Table to Lab Analysis active and delete the relationship between Lab Analysis and Factory Analysis.

Then create a few measures like

Lab analysis PH = SELECTEDVALUE( 'Lab Analysis'[ph value])

Factory analysis PH = SELECTEDVALUE( 'Factory Analysis'[ph value])

Difference = [Lab analysis PH] - [Factory analysis PH]

Then if you use columns from Calendar and Digester Reference Table on your table visual it should work.