Get the value of a column subject to the max value of another colum

[AgustinLopez]

Hello!, I'm new with this of Power Bi, and I'm struggling to get a Dax formula to work properly.

I have the following in example.

Week           Kilos
1                  10
2                  20
3                  30
4                  40

And also, a slicer with the weeks.

I need a Dax that shows in a label the kilos of the week that is max of the slicer.
I.e.
Slicer is from week 2-4, the label has to show 40 Kilos
if Slicer is from week 2-3, the label has to show 30 kilos

Thanks for your help in advance!

[AlB]

Hi @AgustinLopez 

If you are going to use the measure in a card visual, this should suffice:

Measure =  MAX(Table1[Kilos])

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak · Accepted solution]

@AgustinLopez , Try a measure like

meausre =
var _max = maxx(allselected(Table), Table[week])
return
calculate(sum(Table[Kilos]), filter(Table, Table[week] =_max))

But better to have separate week table