Forum Discussion
Helper IIHow to SUM a measure using MAX
I see what you mean - have you considered creating a deduped version of the table then calculating for each row, eliminating the dedupe inside the calc?
Helper IIIt's actually doing both each line in the screen shot represents a Production Order where we produced an item. When we do this we log what the Expected Yield and Actual Yield was for the Production Order, but every once in a while our production crew double enters the yield by mistake. I am trying to only take the last entry for each Production Order and then sum all the totals. If I SUM all it counts the duplicates which I dont want.
My measure is taking the MAX entry number, in the total it is returning that MAX entry data rather than the SUM.
I hope I explained this well enough.
Advocate IVI see what you mean - have you considered creating a deduped version of the table then calculating for each row, eliminating the dedupe inside the calc?
- Kfausch
This took a while, but I was able to make it work this way. I feel as though there must be a formula that can be used, but I am happy it is working. Thank you for your suggestions!
v-piga-msftResident Rockstar
Hi Kfausch ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share the data sample and your desired output so that we could help further on it.
Best Regards,
Cherry