What should you include in the DAX expression?

You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.

You plan to create a security role named User Security for the dataset. You need to filter the dataset based on the current users.

What should you include in the DAX expression?
A . [UserPermissions] – USERNAME()
B . [UserPermissions] – USERPRINCIPALNAME()
C . [User] = USERPRINCIPALNAME()
D . [User] = USERNAME()
E . [User] = USEROBJECTID()

View Answer

Answer: D

Explanation:

USERNAME() returns the domain name and username from the credentials given to the system at connection time.

It should be compared to column name of User, which in DAX is expressed through [User].

Reference: https://docs.microsoft.com/en-us/dax/username-function-dax