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-Pac...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

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

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

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

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    10 years ago

    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
      10 years ago

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