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 everyone. If someone could help me with the solution, I would be very appreciate.
Every Store ID supposed to get 1 POD from only 1 Warehouse ID, but in this case you can see 1 of Store ID's has dupliacted value, because it's getting a POD from 2 Warehouse ID and in the end get sum of Final POD which is supposed to be 4, not 5.
I assume MAX function may help here.
Please help, thank you.
Solved! Go to Solution.
@Pulyk , Try a measure like
SumX(summarize(Table, Table[Store], "_1", Max(Table[Final POD])), [_1])
@Pulyk , Try a measure like
SumX(summarize(Table, Table[Store], "_1", Max(Table[Final POD])), [_1])
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 |
---|---|
98 | |
96 | |
78 | |
72 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |