SummarizeColumns and DistinctCount

[vincentakatoh]

Hi, 

1) In original table, "Data", created new measure

InputFn = DISTINCTCOUNT(Data[SerialNumber])

2) Create new table, "RollYieldLine", using below, 

RollYieldLine = 
    SUMMARIZECOLUMNS(
	'Data'[station],
	'Data'[Line],
        'Data'[TestDate],
        "FnPassCount",COUNTROWS(FILTer('data',[TestResultsFn]="P")),
        "FnFailCount",COUNTROWS(FILTer('data',[TestResultsFn]="f")),
	"InputFnLine",DISTINCTCOUNT(Data[SerialNumber]),
        "YieldFn",DIVIDE(sum(Data[FnPassCount]),Data[InputFn],1)
	)

My Problem: InputFnLine and InputFn give diffferent results. Can advise what is wrong with below or what is wrong with using distinctcount in summarisecolumns?

"InputFnLine",DISTINCTCOUNT(Data[SerialNumber]),

[v-qiuyu-msft · Accepted solution]

Hi @vincentakatoh,

The "InputFnLine" in the new table will calculate the distinct count for each group, which grouped by the 'Data'[station], 'Data'[Line] and 'Data'[TestDate]. 

The measure InputFn will be affected by row context. If you want to display the same results as in new table, you can drag a table visual, only place the 'Data'[station], 'Data'[Line], 'Data'[TestDate] and the measure measure InputFn. 

You can download the attached pbix file to see the sample. 

Best Regards,
Qiuyun Yu