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?
Anonymous
what's the expected output? could you pls also provide some sample data?
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)