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? Currently roll yield applies for station to product and date to week. 

 

RollYieldFam = 
    SUMMARIZECOLUMNS(
		'Data2'[Customer],
		'Data2'[Family],
    	'Data2'[station],		
		'Data2'[TestDate],
		"OutputFr",sum(Data2[OutputFr]),
		"FrPassCount",sum(Data2[FirstPassQty]),
        "FrFailCount",sum(Data2[FirstFailQty]),
		"InputFr",SUMX(data2, [FirstFailQty]+Data2[FirstPassQty]),
        "YieldFr",DIVIDE(sum(Data2[FirstPassQty]),sum(Data2[InputFr]),1)
        	)

 

 

Yield_Roll = CALCULATE(PRODUCT([YieldFr]))

 

 

 

Need Help

3 Replies

    • 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