Forum Discussion

vincentakatoh's avatar
vincentakatoh
Helper IV
8 years ago
Solved

Datetable and Summarize Column

Hi,    Used summarise column to calculate roll yield (= A*B*C). Also created a Datetable.    Que: Any way to re-write dax such that roll yield does not apply when I drill up from date to week? Cu...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi vincentakatoh,

 

Below measure can return correct percentage (CountPass/Totalcount) per level.

Measure Yield = DIVIDE(SUM(Yield[CountPass]),SUM(Yield[TotalCount]),1)

   

 

But, based on my test, it seems that PRODUCT function always evaluates the product value for each detailed row in whole table. So, when we drill up to weekly level, it returns wrong result.

 

If you work it out later, appreciate that you could share your solution here.

 

Best regards,
Yuliana Gu