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 have spend the hole weeked trying to create a DAX mesure without success, I ask for help to the community
In the following Table I need to calculate the total of Elements "based" on column "Quantity", but I need to consider only 1 value when Detail of Element are multiple (In that case Quantity is always the same).
Element | Detail | Quantity | DATE | Nom |
a | 1 | 10 | 10-oct | AAA |
a | 2 | 10 | 10-oct | AAA |
a | 3 | 10 | 10-oct | AAA |
b | 1 | 12 | 15-nov | AAA |
b | 2 | 12 | 15-nov | AAA |
c | 1 | 15 | 15-nov | AAA |
c | 2 | 15 | 15-nov | AAA |
c | 3 | 15 | 15-nov | AAA |
c | 4 | 15 | 15-nov | AAA |
d | 2 | 5 | 09-oct | BBB |
e | 3 | 2 | 08-oct | BBB |
f | 5 | 1 | 11-nov | CCC |
Expected result is as follow:
Number of Quantity | ||
a | 10 | |
b | 12 | |
c | 15 | |
d | 5 | |
e | 2 | |
f | 1 |
And the mesure need to be able to be calculated also at Date and Name level
DATE | Calculated Quantity | |
October | 17 | |
November | 28 |
Name | Calculated Quantity | |
AAA | 37 | |
BBB | 7 | |
CCC | 1 |
I get confused with the Filter level to apply
Any help will be very appreciated
Solved! Go to Solution.
Hi @erfaldo
Try this measure and use that in those scenarios:
Calculated Quantity =
Var _A = SUMMARIZE('Table','Table'[Element],'Table'[Quantity],'Table'[DATE],'Table'[Nom])
return
sumx(_A,[Quantity])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @erfaldo
Try this measure and use that in those scenarios:
Calculated Quantity =
Var _A = SUMMARIZE('Table','Table'[Element],'Table'[Quantity],'Table'[DATE],'Table'[Nom])
return
sumx(_A,[Quantity])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Incredible simple...I was getting confused trying with filters...
Thank you for your Help!!!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |