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.
v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi gp201641 ,

 

Please try:

Measure = COUNT('DEFECT DATA BASE'[Defect])/CALCULATE(DISTINCTCOUNT('DEFECT DATA BASE'[Job Number]),ALL('DEFECT DATA BASE'))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.