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.
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!
@Anonymous , I case you need value only at few place
then use isinscope
if( isinscope(Table[BKT Prive]) , [calculated 11], blank())
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |