Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Does anyone know why this measure is throwing up an error 'The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Sales PW =
VAR CurrentWeek =
SELECTEDVALUE ( MyDateTable[Week Number] )
VAR CurrentYear =
SELECTEDVALUE ( MyDateTable[Year] )
VAR MaxWeekNumber =
CALCULATE ( MAX ( MyDateTable[Week Number] ), ALL ( MyDateTable ) )
RETURN
SUMX (
FILTER (
ALL ( MyDateTable ),
IF (
CurrentWeek = 1,
MyDateTable[Week Number] = MaxWeekNumber
&& MyDateTable[Year]
= CurrentYear - 1,
MyDateTable
= CurrentWeek - 1
&& MyDateTable[Year] = CurrentYear
)
),
[Total Hours]
)
Solved! Go to Solution.
Hi @android1,
Based on my test, it seems that you have forgotten add a column name in 'MyDateTable
= CurrentWeek - 1'
You could refer to below formula and test it again:
Sales PW = VAR CurrentWeek = SELECTEDVALUE ( MyDateTable[Week Number] ) VAR CurrentYear = SELECTEDVALUE ( MyDateTable[Year] ) VAR MaxWeekNumber = CALCULATE ( MAX ( MyDateTable[Week Number] ), ALL ( MyDateTable ) ) RETURN SUMX ( FILTER ( ALL ( MyDateTable ), IF ( CurrentWeek = 1, MyDateTable[Week Number] = MaxWeekNumber && MyDateTable[Year] = CurrentYear - 1, MyDateTable[Year] = CurrentWeek - 1 && MyDateTable[Year] = CurrentYear ) ), [Total Hours] )
Hope it could help you
Regards,
Daniel He
Hi @android1,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @android1,
Based on my test, it seems that you have forgotten add a column name in 'MyDateTable
= CurrentWeek - 1'
You could refer to below formula and test it again:
Sales PW = VAR CurrentWeek = SELECTEDVALUE ( MyDateTable[Week Number] ) VAR CurrentYear = SELECTEDVALUE ( MyDateTable[Year] ) VAR MaxWeekNumber = CALCULATE ( MAX ( MyDateTable[Week Number] ), ALL ( MyDateTable ) ) RETURN SUMX ( FILTER ( ALL ( MyDateTable ), IF ( CurrentWeek = 1, MyDateTable[Week Number] = MaxWeekNumber && MyDateTable[Year] = CurrentYear - 1, MyDateTable[Year] = CurrentWeek - 1 && MyDateTable[Year] = CurrentYear ) ), [Total Hours] )
Hope it could help you
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |