Forum Discussion
Help with this DAX error
Right out of the gate, fail. I am dumbfounded as to why this won't work to create a measure:
AsiaPacific_%complete =
MAXX(
FILTER(
'Completion Region',
'Completion Region'[Region] = "Asia-Pacific"
)
'Completion Region',
'Completion Region'[% Complete]
)
The message I recieve is as follows:
The syntax for ''Completion Region'' is incorrect. (DAX( MAXX( FILTER( 'Completion Region', 'Completion Region'[Region] = "Asia-Pacific" ) 'Completion Region', 'Completion Region'[% Complete] ))).
When I go to the DAX reference, it is clear on the correct usage:
MAXX(<table>,<expression>)
FILTER(<table>,<filter>)
Any help would be most appreciated.
AsiaPacific_%complete =
MAXX(
FILTER(
'Completion Region',
'Completion Region'[Region] = "Asia-Pacific"
)
,
'Completion Region'[% Complete]
)
3 Replies
- VvelardeCommunity Champion
AsiaPacific_%complete =
MAXX(
FILTER(
'Completion Region',
'Completion Region'[Region] = "Asia-Pacific"
)
,
'Completion Region'[% Complete]
)