Forum Discussion
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 ...
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.