Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |