Return Sales of Max Value Year

[Oscartv97]

Hello,

I have the following Table1:

Year	Sales
2017	1
2017	1
2018	2
2018	2
2019	3
2019	3

Im trying to get the sales of my max year (2019).

I've tried: 

MaxYearSales = CALCULATE(SUM('Table1'[Sales]), FILTER('Table1', MAX('Table1'[Year])))

And it returns me 12, not 6.

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[amitchandak]

@Oscartv97 , Try one of the two

MaxYearSales = CALCULATE(SUM('Table1'[Sales]), FILTER('Table1', 'Table1'[Year]= MAX('Table1'[Year])))

MaxYearSales =
var _max = maxx(allselected('Table1', 'Table1'[Year])
return
CALCULATE(SUM('Table1'[Sales]), FILTER('Table1', 'Table1'[Year]= _max))

[Fowmy · Accepted solution]

@Oscartv97 

Try:

MaxYearSales = 

VAR _YEAR = MAX('Table1'[Year]) RETURN
    CALCULATE(
        SUM('Table1'[Sales]), 
        'Table1'[Year] = _YEAR,
        ALL('Table1'[Year])
    )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn