Forum Discussion

gp201641's avatar
gp201641
Frequent Visitor
4 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.
gp201641's avatar
gp201641
Frequent Visitor
4 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
4 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.