DAX help

[Anonymous]

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 iam using DAX =Calculate(distinct(name),Hasloggedin="Yes")  I am getting an error multiple values found where single value expected, how to do it??

[Mariusz]

Hi @Anonymous 

You can use the below DAX measures.

Yes = 
CONCATENATEX(
    FILTER(
        YourTable,
        YourTable[Hasloggedin] = "Yes"
    ),
    YourTable[Name], ", "
)

No = 
CONCATENATEX(
    FILTER(
        YourTable,
        YourTable[Hasloggedin] = "No"
    ),
    YourTable[Name], ", "
)

Best Regards,
Mariusz

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

Please feel free to connect with me.

[Anonymous]

works fine but Iam having problem If i have multiple value in my name column, if i use disitnct its showing the same error (multuiple values supplied when expecting 1 value)

[Mariusz · Accepted solution]

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.

[Anonymous]

works like charm, thanks