Add unique values.

[Syndicate_Admin]

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.

[Anonymous]

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.

[mussaenda]

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!