Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi life Gurus,
what systax errror in this?
[countryName] =
VAR B = DISTINCTCOUNT('VW_UserConfig'[countryName])
,FILTER('VW_UserConfig','VW_UserConfig'[EmailAddress] == USERPRINCIPALNAME()))
RETURN
B
Solved! Go to Solution.
This is working for me thanks any way:
[Name] = CALCULATETABLE (
VALUES ( 'VW_UserConfig'[countryName] ),
'VW_UserConfig'[emailaddress] = USERPRINCIPALNAME ())
This is working for me thanks any way:
[Name] = CALCULATETABLE (
VALUES ( 'VW_UserConfig'[countryName] ),
'VW_UserConfig'[emailaddress] = USERPRINCIPALNAME ())
Hi,
I am not sure how your desired outcome looks like, but please try the below.
countryName =
VAR B =
CALCULATE (
DISTINCT ( 'VW_UserConfig'[countryName] ),
FILTER (
'VW_UserConfig',
'VW_UserConfig'[EmailAddress] == USERPRINCIPALNAME ()
)
)
RETURN
B
Or,
countryName =
VAR B =
CALCULATE (
DISTINCTCOUNT ( 'VW_UserConfig'[countryName] ),
FILTER (
'VW_UserConfig',
'VW_UserConfig'[EmailAddress] == USERPRINCIPALNAME ()
)
)
RETURN
B
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |