Top 4 producent regardless time

[mic_rysel]

HI, I would like to create a chart with top4 producers all the time and show them on timeline

I have a measure:

Sales 6month = DIVIDE(

calculate(sum(Sales);MONTH(Date) >= MONTH(TODAY())-6)

;

CALCULATE(sum(Sales);MONTH(date) >= MONTH(TODAY())-6;ALL(Producer))

If I put it into filter top4 with producers it doesnt work properly because of date on X axis. I would like to choose 4 top producers and then show them on X chart with timeline.

[Greg_Deckler]

Try:

Sales 6month = DIVIDE(

calculate(sum(Sales);FILTER(ALL('Table');MONTH(Date) >= MONTH(TODAY()) ) - 6)

;

CALCULATE(sum(Sales);FILTER(ALL('Table');MONTH(date) >= MONTH(TODAY()) ) - 6;ALL(Producer))

You need to override the filter context for your dates.

[mic_rysel]

it doesnt work properly, If i do with Your solution every producer has the same sales value each month and one month as blank.