Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Count non duplicate values

Hi all   I need to have a kpi for the number of times a "C" appears in column called FSSC 22000   The formula I use is very simple:     FSSC 22000 Compliance = CALCULATE(COUNT('Suppliers Comp...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    o59393 

    Have you tried distinctcount

    FSSC 22000 Compliance = CALCULATE(DISTINCTCOUNT('Suppliers Compliance'[FSSC 22000]),'Suppliers Compliance'[FSSC 22000]="C")
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

o59393 

Have you tried distinctcount

FSSC 22000 Compliance = CALCULATE(DISTINCTCOUNT('Suppliers Compliance'[FSSC 22000]),'Suppliers Compliance'[FSSC 22000]="C")
o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago

Thanks!

 

Just did what you mentioned+ changing the denominator with the distinctcount also.

 

FSSC 22000 Compliance = CALCULATE(DISTINCTCOUNT('Suppliers Compliance'[Id]),'Suppliers Compliance'[FSSC 22000]="C") / DISTINCTCOUNT('Suppliers Compliance'[Id])

 

Regards.