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...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    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.

YukiK's avatar
YukiK
Impactful Individual
4 years ago

You should be get the result with DAX like the following:

Your Measure = 

CALCULATETABLE(
    VALUES(CertificationName),
    YourColumn in { "YourValue" }
)

 

Note, this will return a table.


Hope this helps!