Forum Discussion
SummarizeColumns and DistinctCount
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]),
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
1 Reply
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