Forum Discussion
thebaguette
4 years agoNew Member
Get dimension value based on minimum metric value
Hi, I have the following table : EAN Store Price Date AAAAA Amazon 100 01/01/2022 AAAAA Ebay 120 01/01/2022 AAAAA Amazon 110 08/01/2022 AAAAA Ebay 130 08/01/2022...
amitchandak
Super User
4 years agothebaguette , Try a measure like
Rankx(Filter(allselected(Table[EAN], Table[Month Year], Table[Store]), [EAN] = Max([EAN]) && [Month Year] = max([Month Year])), calculate(Min(Table[Price])),,asc,dense)
you can use visual level filter of 1
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
thebaguette
4 years agoNew Member
Hi amitchandak,
Thank you for your answer. Unfortunately it didn't work. I did some calculation before connecting the table to PBI to make it work 🙂