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

 

 

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.

4 Replies

  • 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!

  • truptis's avatar
    truptis
    Community Champion
    4 years ago

    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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    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.