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 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.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |