Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Anildp ,
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.
Hi @Anildp ,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |