Return unique column text values

[AlanP514]

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 error 
please help me

 

[v-xiaotang · Accepted solution]

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.

[truptis]

Hi @AlanP514 ,
Try this:
Result_Col = calculate(distinct(name), filter(tablename,certificate="1 star")

If the solution helps, then please mark it has a solution. Thanks.

Regards,

TruptiS

[AlanP514]

That will not 

[YukiK]

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!