What should you do?

You have a Power Bl 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?
A . Modify the Customer Count measure to use the count function.
B . Modify the table relationship between the Customers table and the Sales table to use a Cross filter direction of Both.
C . Modify the table relationship between the Products table and the Sales table to use a Cross filter direction of Both
D . Modify the Customer Count measure to use the countx function.

View Answer

Answer: B

Explanation:

References:

https://docs.microsoft.com/en-us/power-bi/desktop- create-and-manage-relationships