Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit.
(Click the Exhibit button.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit.
(Click the Exhibit button.)
You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You need to create a measure of Sales[SalesAmount] where Product[Color] is Red or Product[Size] is 50.
Which DAX formula should you use?
A.
B.
C.
D.
References: https://msdn.microsoft.com/query-bi/dax/filter-function-dax
C
14
0
Not B: “The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression.”
1
0