Forum Discussion
Need Help with Summing Values
Anonymous
pls see the attachment below. Hope it's helpful.
still have a question. why the date for expected output is 2020/1/15 and 2020/1/16?
ryan_mayu Yes here is another example that I hope makes more sense:
on day 31 the count of Analysis (tests) is 2. the cycle time for one test is 30 so the value should be 60 which it is. however, the Review time only occurs once regardless of the amount of tests completed (Count of Analysis). the review time is 60 minutes. so the expected value is 60 however I am getting 120.
Let me know if the pictures are not enough and I will do my best to post the data. sorry this is my first time on this community forum! thanks for the help!
Here is the data baswed on the above explanation of expected outcome.
Here is a photo of the data in the transform data window
Anonymous
cycle time= count of analysis * 30
What's the DAX of reviewing time and lead time?
Lead Time is SUM( Cycle Time + Lead Time)
Review Time should just be Distinct count of analysis*Lead time value in this case 60.
so it should just be Lead Time = 1*60 for this case. I have list of a bunch of different lead times.
Anonymous
if i didn't misunderstand your explaination.
pls try
=distinctcount(analysis)* [testing cycle time]
In the Review Time column in the above picture, every row should have a value of 60. but the output I am getting is Review Time = Count Analysis*60. I only want it to show 60*1
Anonymous
maybe you can try distinctcount(analysis)* average(testing leadtime)
Yea still no luck. the only way to exaplain it is this way:
My lead time is the sum of cycle time and review time. if I have 10 samples to test my cycle time will be multiplied by 10. but I review the entire set of 10 samples one time.
so if I have 10 samples, my cycle time is 10, and my review time is 50 then the value of my lead time should be Lead Time = Cycle*#samples + Review Time = (10*10) + 50 = 150 minutes. my review time column contains a lot of different values for Review time based on the specific test in the Analysis column. so averaging, using Min, or Max will not work. any suggestions is appreciated