need help

[faheem_Latif_BI]

Hi life Gurus,

what systax errror in this?

[countryName] =

VAR B = DISTINCTCOUNT('VW_UserConfig'[countryName])
,FILTER('VW_UserConfig','VW_UserConfig'[EmailAddress] == USERPRINCIPALNAME()))
RETURN
B

[faheem_Latif_BI · Accepted solution]

This is working for me thanks any way:

[Name] = CALCULATETABLE (
VALUES ( 'VW_UserConfig'[countryName] ),
'VW_UserConfig'[emailaddress] = USERPRINCIPALNAME ())

[Jihwan_Kim]

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