Forum Discussion
Distinct formula with filter not working for calculated column
Hello,
I have a table with a calculated column. I want to show distinct values from 'ACT 2023'[Cost Center Group] that include "ABC". This is my current formula but returns error.
test = DISTINCT(FILTER('ACT 2023', CONTAINSSTRING('ACT 2023'[Cost Center Group], "ABC")))
1 Reply
ryan_mayuSuper User
pls try to use this DAX to create a table. Distinct will return a list.