AGGR Dimension only shows when a selection is made

[davyqliks]

Hi,

I am trying to show the max expiry date  when there are more than one expiry date as a dimension, grouping by  name, using the following:

=Aggr(Only({<[Expiry Date]={"$(=max([Expiry Date]))"}>}[Expiry Date]),name)

When i have a name selected the value is correct however with no selections made i see no Expiry Dates.

Can anyone recommend how i can get the expiry to show per name when no selections are made in the table?

thank you in advance.

Daniel 

[Digvijay_Singh]

Not sure of your exact situation if its a filter box or something else but check if this makes sense in your situation - 

=if(getselectedcount(name),

Aggr(Only({<[Expiry Date]={"$(=max([Expiry Date]))"}>}[Expiry Date]),name),

Aggr(Only([Expiry Date]),name))

OR

=if(getselectedcount(name),

Aggr(Only({<[Expiry Date]={"$(=max([Expiry Date]))"}>}[Expiry Date]),name),

Aggr(Only([Expiry Date]),[Expiry Date]))

OR

Share a sample, someone will surely find the right combination..

[BrunPierre]

Maybe try this

=Max(Aggr(Only({<[Expiry Date]={"$(=max([Expiry Date]))"}>}[Expiry Date]),name))

[davyqliks]

thank you so much for taking the time to assist, this is a table. unfortunately using the above i still only get a value when a name is selected.

thanks again

Daniel

[davyqliks]

Hi,

Thank you for taking the time to reply.

sorry to say but i am seeing syntax error with this, when i remove the Max and (), i get the same with data showing only when a name is selected.

thanks again for your time. much appreciated

Daniel