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,
In a table I have all the pieces done by a production machine. Each piece is related to a Run ID (Run column). For the date selected with the slicer, I want to be able to calculate the sum of Vol_used for all the pieces of the same Run. Sometimes one L.wanted can be related to more than one Run (Like 31 and 30 in the example).
Here is the expected result:
I share the pbi files: https://www.dropbox.com/s/s9nmmfhr7wn47ui/TEst_BI.pbix?dl=0
Thank you
something like this?
runmeasure =
SUMX ( VALUES ( tablename[Lwanted] ), SUM ( table[volume] ) )
Proud to be a Super User!
Hi,
There is the formula that give me the expected result.
CALCULATE(SUMX(VPIECE;VPIECE[Vol_used]);VALUES(VPIECE[Run]);ALLEXCEPT(VPIECE;VPIECE[Run];VPIECE[DATE]))
But in my real table it doesn't work because it says that there is too many parameters and the server allow a maximum of 2100. So I need something else. Any idea will be welcome!
Thank you
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |