Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |