Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX help

I have my table like this Name     Hasloggedin A             Yes B              Yes C              No D              Yes   I want ot return names where hasloggedin= Yes and hasloggedin=no. If...
Need Help
Show and Tell
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

    Try the below

    Yes = 
CONCATENATEX(
    CALCULATETABLE(
        VALUES( YourTable[Name] ),
        YourTable[Hasloggedin] = "Yes"
    ),
    YourTable[Name], ", "
)
    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski



Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

Try the below

Yes = 
CONCATENATEX(
    CALCULATETABLE(
        VALUES( YourTable[Name] ),
        YourTable[Hasloggedin] = "Yes"
    ),
    YourTable[Name], ", "
)
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski



Anonymous's avatar
Anonymous
Not applicable
7 years ago

works like charm, thanks