Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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??
Solved! Go to Solution.
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], ", " )
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)
works like charm, thanks
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |