Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
AsiaPacific_%complete =
MAXX(
FILTER(
'Completion Region',
'Completion Region'[Region] = "Asia-Pacific"
)
,
'Completion Region'[% Complete]
)
AsiaPacific_%complete =
MAXX(
FILTER(
'Completion Region',
'Completion Region'[Region] = "Asia-Pacific"
)
,
'Completion Region'[% Complete]
)
Filter retrieve a table with all the rows in Asia Pacific Region, next with Maxx you can find the max value in %Complete column.
Thank you. God bless Peru. I miss Lake Titicaca.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |