Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago
Solved

Return unique column text values

Need help , which Dax will help to fetch the unique name from name column and condition Should be Certification level should be 1 The above Attached file is i applied it is returning err...
  • v-xiaotang's avatar
    4 years ago

    Hi AlanP514 

    Try this dax expression, it will return a table with unique name where level="1 Star".

    Table_unique_name = CALCULATETABLE(DISTINCT('Table'[Name]),FILTER('Table','Table'[Level]="1 Star"))

    Best Regards,

    Community Support Team _Tang

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