Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello experts,
My raw data is following.
Name | Date | Period |
Jan | 1/1/2019 | 1 |
Feb | 2/1/2019 | 2 |
Mar | 3/1/2019 | 3 |
Apr | 4/1/2019 | 4 |
I am passing on the Name as slicer to the users of the report.
What I am hoping for DAX to return is the corresoponding max value of the Period when multiples values are selected from the slicer. For example,
when the selection is following
I am hoping for DAX to return following
Solved! Go to Solution.
I would expect in this scenario that the simple MAX( column ) would work too
Max Period = MAX('Table'[Period])
Seems to work for me, see Page 4 and Table 7 in attached.
Probably something along the lines of:
MAXX(ALLSELECTED('Table'),[Period])
I would expect in this scenario that the simple MAX( column ) would work too
Max Period = MAX('Table'[Period])
Thanks a lot @d_gosbell and @Greg_Deckler
@d_gosbelltested. It did not work. If you have a workbook where it works would be great if you can please upload/share/show.
@Greg_Deckler thanks for the reponse.
So far, I tried this. But did not get what I wanted. Since I am passing the Name to create slicer, ALLSELECTED does not see the corresponding period number in MAXX. SELECTEDVALUE does see the correponding value based on the slicer from the same table but does not allow MAXX to be applied on it.
Seems to work for me, see Page 4 and Table 7 in attached.