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 = query1[residue value]+query2[flow value]
where residue value = query1[new flow value]+query1[shrink volume]
New flow value and shrink volume are again calculated columns and the values match with my data and looks right.
I'm not able to figure out the calculation for Imbalance. Please let me know if anyone knows the solution.
7 Replies
Anonymous share sample data and expected result. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Anonymous
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.
