Forum Discussion
DAX
Hi, I want to need with help with my measure. There's no error but the numbers don't look right. I'm trying to add a calculated column from query 1 and a column from query 2. Imbalance = quer...
Anonymous
do you have relationships between tables?
if so, try
Imbalance = query1[residue value]+ RELATED(query2[flow value])if not, it will not be summed up or you have to define rule whats exactly cell [flow falue] from all table2 should be added
az38 I do have relationship between the tables and it's based on the dates.
But the meters in table 1 and the meters in table 2 are different (which means they have a same column but different values and flow value doesn't exist in table 1).
May be I can filter based on the meter I want to show for table 2. Though I'm not sure how to filter that out.