Create a Calculated Column from Different Tables/ queries based on calculation columns

[Anonymous]

Hi All,

need some help in creating the calculation 

 I have 3 queries 

 below listed is actual data output from the Queries 

Query 1

Description	Amount
BUCKET 1	$575.00
BUCKET 2	$285.00
BUCKET 3	$135.00
BUCKET 4	$155.00	BUCKET 1 -(BUCKET 2 + Bucket 3)
BUCKET 5	$125.00

Query 2: output 

Description	Amount
BUCKET 6	$100.00
BUCKET 7	$70.00
BUCKET 8	$25.00
BUCKET 9	$5.00	(BUCKET 6 - (Bucket 7 + Bucket 8))
BUCKET 10	$45.00

Query 3: Output 

Description	Amount
Bucket 11	100
Bucket 12	45
Bucket 13	25
Bucket 14	30	(Bucket 11 - ( Bucket 12+Bucket 13))

Problem / Help required

I have to create a New Calculation which has to be calculated like below

Bucket 15 = BUCKET 4 + Bucket 9 + Bucket 14

Can someone please help me with this, as I don't know how to create a calculation on top a row inside the table.

Thanks in advance 

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create measure like DAX below.

Sum=

var d4 = CALCULATE(MAX(Query 1[Amount]),FILTER(Query 1,Query 1[Description]="BUCKET 4"))

var d9 = CALCULATE(MAX(Query 2[Amount]),FILTER(Query 2,Query 2[Description]="BUCKET 9"))

var d14 = CALCULATE(MAX(Query 3[Amount]),FILTER(Query 3,Query 3[Description]="BUCKET 14"))

return d4 +d9 +d14

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-xicai  thanks it worked 🙂