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()

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

Latest DP-500 Dumps Valid Version with 83 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments