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