Compare all the values in a row with a number, execute Measure1 if true or Measure 2 if false

[Madhun]

Hello,

I'm trying to write a logic where i need to calculate a measure based on specific weeks as shown below. However i end up either getting one of the following errors
"A single value for column in table cannot be determined power bi" or
"The expression refers to multiple columns Multiple columns cannot be converted to scalar value"

If(
Table[FY_Year_Weeknum]<202248,
Measure1,
Measure2
)

[amitchandak · Accepted solution]

@Madhun , You have to use selectedvalue or max

If(
selectedvalues(Table[FY_Year_Weeknum])<202248,
Measure1,
Measure2
)

or

If(
max(Table[FY_Year_Weeknum])<202248,
Measure1,
Measure2
)

[v-yiruan-msft · Accepted solution]

Hi @Madhun ,

It seems you are creating a measure,  please update the formula of your measure as below. Please find the details in the attachment.

Measure = IF ( SELECTEDVALUE ( 'Table'[FY_Year_Weeknum] ) < 202248, [Measure1], [Measure2] )

In addition, you can review the following blog to get a better understanding of why you are getting this DAX error message.

DAX error messages in Power BI

Best Regards

[Madhun]

@v-yiruan-msft ,

Thank you for your response. I used the same logic and it worked for me 🙂

[amitchandak · Accepted solution]

@Madhun , You have to use selectedvalue or max

If(
selectedvalues(Table[FY_Year_Weeknum])<202248,
Measure1,
Measure2
)

or

If(
max(Table[FY_Year_Weeknum])<202248,
Measure1,
Measure2
)

[Madhun]

@amitchandak 

Thanks for the response. Selectedvalue() function did the job for me 🙂