Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
joglidden
Advocate III
Advocate III

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.

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

AsiaPacific_%complete =
MAXX(
FILTER(
'Completion Region',
'Completion Region'[Region] = "Asia-Pacific"
)
,
'Completion Region'[% Complete]
)




Lima - Peru

View solution in original post

3 REPLIES 3
Vvelarde
Community Champion
Community Champion

AsiaPacific_%complete =
MAXX(
FILTER(
'Completion Region',
'Completion Region'[Region] = "Asia-Pacific"
)
,
'Completion Region'[% Complete]
)




Lima - Peru

Filter retrieve a table with all the rows in Asia Pacific Region, next with Maxx you can find the max value in %Complete column.




Lima - Peru

Thank you. God bless Peru. I miss Lake Titicaca. 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.