Forum Discussion

joglidden's avatar
joglidden
Advocate III
10 years ago
Solved

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

  • Vvelarde's avatar
    Vvelarde
    Community Champion

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

    • Vvelarde's avatar
      Vvelarde
      Community Champion

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

      • joglidden's avatar
        joglidden
        Advocate III

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