Forum Discussion
DAX
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.
Anonymous
as parry2k mentioned data sample would make the solution find process more easier 🙂
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
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.
