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.
kongyuancn's avatar
kongyuancn
Helper II
3 years ago

Hi gp201641 , I think you should create a Product table which include all your product. And then add a relation between this table and your defect table. Then District Vehicle Count = DISTINCTCOUNT(ALL('Product Table'[Job Number ]))