Which DAX formula should you use?

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 in the Products table.
You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced
column must store a value of TRUE if 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.)

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 in the Products table.
You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced
column must store a value of TRUE if 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.
Option A

B.
Option B

C.
Option C

D.
Option D



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Carlos Escobar

Carlos Escobar

A and C

Hanz

Hanz

No is not correct!!
Answer B and C is the rigth one.

Explenation:
In the “Products” table is the column [Maximum Sales Price]
In the “Invoice Line Items” table is the column [Unit Sales Price]
Also the right answer here is:

=IF([Unit Sales Price] > RELATED(Products[Maximum Sales Price]), TRUE, FALSE)
=IF([Unit Sales Price] > LOOKUPVALUE(Products[Maximum Sales Price], Products[Product Id], [Product Id]), TRUE, FALSE)

this are the wrong answer:
=IF(RELATED(Products[Unit Sales Price]) > [Maximum Sales Price], TRUE, FALSE)
=IF(LOOKUPVALUE(Products[Unit Sales Price], Products[Product Id], [Product Id]) > [Maximum Sales Price]), TRUE, FALSE)

Ralph

Ralph

exactly B and C