Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]),
Solved! Go to 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
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