Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

I am stumped by this, Maxx([table,[measure) value is less than [ measure] value same filter applied

Dear All,

I am stumped by this, Maxx([table,[measure) value is less than [ measure] value with the same filter applied.

Please suggest whats wrong with this.


MAXX(Education_Metrics,[Tiered Manage Education Score] )= 5.50
and [Tiered Manage Education Score] = 11, same filter applied.
Please suggest where am i going wrong.
Kind Regards,
Hitesh N Ramchandani



Super User II
Super User II

@Hitesh1604 when you are using a measure in a iterator, all the field in current row context will be transited into filter context, ie all the fields in table of Education_Metrics will be transited to filter

@wdx223_Danielthanks for reverting, i do concur. The filter context is the same for both the cases. So the maximum value should;nt be the current filter row value in which case it is 11?

In my view the maximum should be 11. If not how can i come up with the maximum of a  measure please advise.




sorry the above does not work always, and does not give the maximum value always...i am ,lost

Helpful resources



We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors