N-Printing Filter Selection with aggregation

[Anonymous]

I have below issue in n-Printing..

Need to execute below expression to bring in this output in to  Year and Month filter selections

Year:  aggr(max({<[KPI Type]={'Market Share'}Calendar Year]),[Europe Region])

Month:  Date(aggr(Max({<[KPI Type]={'Market Share'}>}[Calendar Month And Year Number]),[Europe Region]),'MM')

please find attachment..

I can use ‘KPI Type’ as Market Share in selection. How can I aggregate with Europe Region? I tried to bring this in different ways but could not!!

I need to aggregate it to Europe Region because I have different Months and Year for latest in a Region, please find below.

[lironbaram]

hi you can do it

but there is something odd with your filter it might result in an array and not a single value

as you use aggr function

any how you can do it like this

in the year filter insert this

=Year=max(aggr(max({<[KPI Type]={'Market Share'}[Calendar Year]),[Europe Region]))

make sure you keep the evaluate or is numeric empty

for the month

=Month= Date(max(aggr(Max({<[KPI Type]={'Market Share'}>}[Calendar Month And Year Number]),[Europe Region])),'MM')