Question:
You have a fact table that contains sales data and the following two date columns: OrderDate ShipDate Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates. You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships. What should you do? Select only one answer. Disable Make this relationship active for both relationships. Enable Apply security filter in both directions for both relationships. Enable Make this relationship active for both relationships. Set the cross-filter direction to both for each relationship.
Author: da-biAnswer:
Disable Make this relationship active for both relationships. This answer is correct.
0 / 5 Â (0 ratings)
1 answer(s) in total