country by Max(parameter) to each date

[yo_peralta23]

Hi, 

I´m trying to do a grapf like this:

New Measure is the important measure in my problem. For each date I´m obtaining the New Measure value for all countries, but I only want to obtain the country with max New Measure value for each month, for example, for March 2019 is Argentina, and for July 2019 is Colombia

I´m trying to do this with Top N filter, but it filters only by Argentina, because this country has the max TOTAL amount of New Measure along all dates.

Thanks in advance

Thanks a lot

[dax]

Hi @yo_peralta23 , 

I think you need to use measure to rank value, then you could apply the measure in filter, and you will get Top N you want. You could referto my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yo_peralta23]

Hi @dax, thanks for your answer

Your graph help me a lot. I´´m so close to obtain my desired result. I only need filter the strikethrough bars. As you can see, I´ve modified the graph, because the value Measure 4 is the value I want to display and also the Top N (with N=1) filter I want to apply

Have any idea about?

Thanks again

[dax]

Hi @yo_peralta23 , 

This won't work for Top N filter, it will show based on category, so it might will get top 2 of total value when you add amount field in it. And when you use measure4 in it, it won't work.  So I suggest you could use my suggestions, use filter on measure which will return your expected output.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yo_peralta23]

Hi @dax 

I dont know if I´m undertanding well, but your idea is "burn" the value of the measure until I filter all the other values?

Because if this is the strategy... what happens when two coutries are over the filter level... and what happens when any country are over the filter level?

This is the problem I see.

Thanks for all your support