Forum Discussion

joglidden's avatar
joglidden
Icon for Advocate III rankAdvocate 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
Icon for Community Champion rankCommunity Champion
10 years ago

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

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity 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
    Icon for Advocate III rankAdvocate III
    10 years ago

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