Forum Discussion

info_algoritmia's avatar
info_algoritmia
Helper II
3 years ago
Solved

Return highest value from a visual table

Hey there,   I need a measure that returns the highest value from the current visual table, take a look at the screenshot below     I have date and total sales in columns, I need the measu...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    3 years ago

    info_algoritmia I see, try this:

     

    SWITCH ( TRUE (),
  ISINSCOPE ( DateTable[Date], MAXX ( ALLSELECTED ( DateTable[Date] ), [Sales] ),
  ISINSCOPE ( DateTable[Month], MAXX ( ALLSELECTED ( DateTable[Month] ), [Sales] ),
  <<else condition>>
)
parry2k's avatar
parry2k
Super User
3 years ago

info_algoritmia not sure what you used in ALLSELECTED, it should ALLSELECTED ( DateTable )

info_algoritmia's avatar
info_algoritmia
Helper II
3 years ago

parry2k   it works when date column is in the visual, but if I changed it to "Months", look, the "51700" is the highest sales value for "dates", not for "months", how can I update this and make it dinamyc? I'd want know to show the "230400" for February isntead