Question 84 of 388
Single answerYou have a Power BI Desktop project that has the model shown in the exhibit. (Click the Exhibit tab.) Customer Count is a measure that uses the CountRows function to calculate the number of customers.You create a table visualization that displays ProductID, Product, and Customer Count.When you view the table, you discover that Customer Count always displays the total number of customers instead of the number of customers who purchased the product.You need to ensure that the table visualization displays the number of customers who purchased each product.What should you do?
AModify the table relationship between the Customers table and the Sales table to use a Cross filter direction of Both.
BModify the Customer Count measure to use the COUNT function.
CModify the Customer Count measure to use the COUNTX function.
✓DModify the table relationship between the Products table and the Sales table to use a Cross filter direction of Both.
✓
Correct Answer: D
Modify the table relationship between the Products table and the Sales table to use a Cross filter direction of Both.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.