Forum Discussion

Anton-G's avatar
Anton-G
Helper I
8 years ago

Add multiple values in measure

Need to create a measure to get a fixed limit value (red line) in a line and stacked column chart. Have week number that I need to create a relationship to. Connects to SQL Server Analysis Services...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anton-G,

 

Since you can add measures, you can try it like below then add it in the line.

Measure =
IF (
    MIN ( 'Date'[Week Number of Year] ) <= 9,
    5,
    IF ( MIN ( 'Date'[Week Number of Year] ) <= 15, 10, 5 )
)

Best Regards,

Dale

Anton-G's avatar
Anton-G
Helper I
8 years ago

Have tried some variations of the question.

Receiving an error when I try.

 

My question:
Measure =
IF (
    MIN ( 'DIM-Calendar'[Week] ) <= 9,
    5,
    IF ( MIN ( 'DIM-Calendar'[Week] ) <= 15, 10, 5 )
)

 

Error:

 

A table showing week numbers from the same place I use in the question.