DAX

[Anonymous]

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.

[az38]

@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

[Anonymous]

@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. 

[az38]

@Anonymous 

as @parry2k mentioned data sample would make the solution find process more easier 🙂

[Anonymous]

@parry2k

@az38

[Anonymous]

@az38 

@parry2k 

The formulas i used

Imbalance = sum(query1(residue available)+sum(query2(flow value)

Residue available = query1(new flow value)+query1(shrink volume)

new flow value = if(sum(query1(flow value)>[limit],77000,query1(flow value)

limit = 77000

shrink volume = query1(new flow value)*query1(shrink %)

shrink % = 0.3581

[parry2k]

@Anonymous you should have a dimension for meters means a table with the unique value of meters and relationship with query 1 and query 2, in visualization use meter from this new meter dimension and all the formula will work as expected.

[parry2k]

@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/38490