You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model has tables named Invoice Line Items and Products.
The Invoice Line Items table has the following columns:
– Product Id
– Unit Sales Price
The Unit Sales Price column stores the unit price of the product sold.
The Products table has the following columns:
– Product Id
– Maximum Sales Price
The Maximum Sales Price column is available only inthe Products table.
You add a column named Is Overpriced to the InvoiceLine Items table.
The Is Overpriced column must store a value of TRUEif the value of the Unit Sales Price is greater than the
value of the Maximum Sales Price.
Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column.
Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)
A.
=IF([Unit Sales Price] > RELATED(Products[MaximumSales Price]), TRUE, FALSE)
B.
=IF(RELATED(Products[Unit Sales Price]) > [Maximum Sales Price], TRUE, FALSE)
C.
=IF([Unit Sales Price] > LOOKUPVALUE(Products[Maximum Sales Price], Products[Product Id], [Product
Id]), TRUE, FALSE)
D.
=IF(LOOKUPVALUE(Products[Unit Sales Price], Products[Product Id], [Product Id]) > [Maximum Sales
Price]), TRUE, FALSE)