Aggr applied to all data

[paulo_costa_ifp]

I have a set of monthy agregated data like lines below:

Monthname    count(TransID)

jan/17         1000

feb/17           500

mar/17          700

apr/17          1500

may/17           350

jun/17           2000

The function below returns the "best" Monthname value:

max(aggr(count({<[trans_type]-={'OXY'}>}[TransID]),[Monthname]))   = 2000

If we filter jan/17 - mar/17, the function will return 1000. I would like to have a similar function, in order to get the best Monthname value from all data. In this way, if we filter jan/17 - mar/17, the function will return 2000.

[vishsaggi · Accepted solution]

May be this:

= max(TOTAL {<Monthname>} Aggr(count({1<[trans_type]-={'OXY'}>}[TransID]),[Monthname]))

[antoniotiman]

Hi Paulo,

try this

max({<Monthname=>} aggr(count({<[trans_type]-={'OXY'},Monthname=>}[TransID]),[Monthname])) 

Regards.

Antonio

[paulo_costa_ifp]

It´snot running fine.