topic Re: Top 4 producent regardless time in DAX Commands and Tips

Top 4 producent regardless time

mic_rysel — Mon, 11 May 2020 10:44:00 GMT

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.

Re: Top 4 producent regardless time

Greg_Deckler — Mon, 11 May 2020 11:11:59 GMT

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.

Re: Top 4 producent regardless time

mic_rysel — Mon, 11 May 2020 12:10:02 GMT

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