Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Count repeated values only once

I have a table as shown in the image with opportunity codes that are unique and do not repeat and I also have a column that is the ID_Cliente that can be repeated several times. I want to get a calc...
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi Syndicate_Admin ,
    Update your counting formula for :

    Column =
    if(CALCULATE ( COUNT ( 'Table'[id] ), ALLEXCEPT ( 'Table','Table'[id] ) )=1,1,blank())
    *Whithout "if" it will just count repeats of every "id".

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!



Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

Hi Syndicate_Admin ,
Update your counting formula for :

Column =
if(CALCULATE ( COUNT ( 'Table'[id] ), ALLEXCEPT ( 'Table','Table'[id] ) )=1,1,blank())
*Whithout "if" it will just count repeats of every "id".

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!