Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Hotspot Solution:
🔹 Human Resources Table (CFO Role) To prevent the CFO from seeing any data in this table: FALSE() This blocks all rows from being visible to the CFO. 🔹 Country Table (Manager Role) To allow each manager to see data only for their own country: Country[Country] = LOOKUPVALUE(Employee[Country], Employee[Email], USERPRINCIPALNAME()) This assumes you have a mapping between the user’s email and their assigned country in an Employee or similar table.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
For Country table → CFO must see everything → filter = True() For Human Resources table → CFO must see nothing → filter = False() so, Human Resources table False() Country = [Email] = USERPRINCIPALNAME ()
Manager Role : Coutry __ Email=USERPRENCIPAL() , HR__ TRUE() CFO Role : Country __ TRUE() HR__ FALSE()
* Answer: Human Resources: - Manager → [Email] = USERPRINCIPALNAME() - CFO → FALSE() Country: - Manager → [Email] = USERPRINCIPALNAME() - CFO → TRUE() * Explanation: - Managers only see their own country’s slice of Sales + HR. - CFO sees all Sales, but no HR.