topic Re: Get the value of a column subject to the max value of another colum in DAX Commands and Tips

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

AgustinLopez — Wed, 02 Dec 2020 12:54:37 GMT

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!

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

amitchandak — Wed, 02 Dec 2020 13:54:45 GMT

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

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

AlB — Thu, 03 Dec 2020 11:26:28 GMT

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