Forum Discussion
How to Determine Unique Values in Table
Hello All, I am trying to figure out a way to determine the unique values in this column. They are a list of departments. Can I write a measure? Once I get a list of the codes that are in this c...
Hi Anonymous what I am trying to accomplish is a slicer of departments that only display the departments that are in my fact ables.
I imported a (view) that contains all the departments in the database, like 250 departments. So my slicer has this huge list of departments, but in my fact tables I can see that only about 20-25 will ever be used/will ever be in the fact tables.
Hi, pfarahani
Does the 'Distinct‘ function not work for you?
If you want to apply a new field to the slicer, you'd better create a calculated table rather than a measure. Then after associating the relationship between the tables, apply this independent field to the slicer.
Best Regards,
Community Support Team _ Eason