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

[Anonymous]

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

[wdx223_Daniel]

@Anonymous 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

[Anonymous]

@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.

Thanks

[Anonymous · Accepted solution]

[Anonymous]

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