Forum Discussion

gp201641's avatar
gp201641
Frequent Visitor
3 years ago
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...
  • gp201641's avatar
    gp201641
    3 years ago

    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.
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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. 

gp201641's avatar
gp201641
Frequent Visitor
3 years ago

Hi Thanks for the quick response, I am not sure how to DISTINCTCOUNT on the Date column " if I distinc count date " Does it not give me the "1" beacuse all are same date.

 

can you please tell me how to try your idea?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Right, my bad. I meant to use a COUNTROWS(), which would count all the rows you have in there, not the distinct values in them. gp201641 's solution is also valid, assuming making such a table wouldn't be too difficult.