Forum Discussion
Kurumi0418
Helper I
8 years agoHow can I get right value?
Hello all sirs.
My question as blow :
I want use Rule Output / WIP = Overall Turn rate history. but why I use C column Calculate value it's different Overall turn rate history value???????
C = CALCULATE(DIVIDE(SUM('WAITING_TIME_REPORT_HISTORY'[Rule Output]),SUM('WAITING_TIME_REPORT_HISTORY'[WIP])),ALLEXCEPT(WAITING_TIME_REPORT_HISTORY,WAITING_TIME_REPORT_HISTORY[GROUP_PROCESS]))
Overall Turn rate history =
DIVIDE(
SUM('WAITING_TIME_REPORT_HISTORY'[Rule Output]),
SUM('WAITING_TIME_REPORT_HISTORY'[WIP])
)
2 Replies
- v-jiascu-msft
Microsoft Employee
Hi Kurumi0418,
I guess the solution is no aggregation. Please refer to the snapshot below and the demo in the attachment. If you have more questions, please modify the demo that we can discuss more.
Best Regards,
Dale
- v-jiascu-msft
Microsoft Employee