Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Add unique values.

Good!!

I need for a table, which contains the name of a profile and the number of people in that profile, in that table the profiles are repeated several times, create:

a DAX measure, which allows me to operate a card on which it shows, the sum of the "people" depending on which Profiles are selected.

That only adds to me once the number of people per profile, there are Profiles that are duplicated, and I need you to add me as a unique value.

Thank you.

2 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    5 years ago

    Hi Syndicate_Admin ,

     

    You can use the DistinctCount in Measure so those that are duplicated profiles will be counted as one only.

     

    Hope this helps!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Syndicate_Admin ,

     

    Could you tell me if your problem has been solved?

    You could use ALLEXCEPT function to remove duplicate profiles. Like

    CALCULATE(COUNT('TABLE'[COLUMN NAME]),ALLEXCEPT('TABLE'[PROFILE]))

     

    Best Regards,

    Stephen Tao

     

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