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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.