Forum Discussion
Solved
DISTINC COUNT (Interaction issue)
Hi Everyone; I am new to using BI Power and appreciate your support on one matter. I like to create a bar chart table which shows Selected Defect Per Unit by week. Defect Per Unit (DPU): you ha...
Hi All who tried to help,
I finally found the solution - Below formulat is What I have been adivesed and worked perfectly.
DPV RATE = COUNTA('DEFECT DATA BASE'[Defect])/CALCULATE(DISTINCTCOUNT('DEFECT DATA BASE'[Job Number ]),ALLEXCEPT('DEFECT DATA BASE','DEFECT DATA BASE'[WK Number]))I hope this also may help someone in the future.
If I understand this correctly, you can try to use DISTINCTCOUNT on the Date column, instead. It will give you leverage to choose what value to pick from, and when. Also it will count each entry for each type of dirt or not that there is.
Hi All who tried to help,
I finally found the solution - Below formulat is What I have been adivesed and worked perfectly.
DPV RATE = COUNTA('DEFECT DATA BASE'[Defect])/CALCULATE(DISTINCTCOUNT('DEFECT DATA BASE'[Job Number ]),ALLEXCEPT('DEFECT DATA BASE','DEFECT DATA BASE'[WK Number]))
I hope this also may help someone in the future.