Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I am seeking for help as i've been trying a couple days to solve this DAX calculation and I just can't figure it out.
I have a Table with orders, categories (SAL_TEMP) unit prices and number of units.
I have created a calculated column with ranges of prices.
Now, i want to calculate the aggregate of each order without considering the dimension"SAL_TEMP" and the calculated colum "BKT Price" but only from the "Contracts" appearing in first instance.
The result should be like this:
The Table1 down below shows how many orders have each category. I'm interested in the "Total" as i want to know for each "BKT Price" how many units there are but only from the "Contracts" appearing on every row.
The Table2 shows how many units have each order.
If i do something like:
I can't attach the Pbix, but there's the table:
Order | SAL_TEMP | BKT Price | Price | Units | Family |
90002842271 | SALDO | 2 - 2.99 | 2,43 | 1 | 185 |
90002842271 | SALDO | 3 - 3.99 | 3,24 | 1 | 173 |
90002842271 | SALDO | 3 - 3.99 | 3,24 | 1 | 177 |
90002842271 | TEMPORADA | 4 - 4.99 | 4,87 | 1 | 316 |
90002856331 | SALDO | 4 - 4.99 | 4,12 | 1 | 676 |
90002856331 | TEMPORADA | 4 - 4.99 | 4,95 | 1 | 942 |
90002842271 | TEMPORADA | 5 - 5.99 | 5,68 | 1 | 268 |
90002842271 | SALDO | 6 - 9.99 | 6,5 | 1 | 188 |
90002842271 | TEMPORADA | 6 - 9.99 | 8,12 | 1 | 133 |
If someone can give me a hand I would be incredibly grateful.
Best regards,
Solved! Go to Solution.
Solved! 💪 I was basically not being aware of the filter context.
Just in case someone is in my pants, the solution is:
And this returns:
Solved! 💪 I was basically not being aware of the filter context.
Just in case someone is in my pants, the solution is:
And this returns:
So far, i have accomplished this. Still not being correct though... @amitchandak thank you!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |