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 try this measure:

 

Highest Value = MAXX ( ALLSELECTED ( YourTable ), [Sales Measure] )
info_algoritmia's avatar
info_algoritmia
Helper II
3 years ago

hey parry2k  it worked but I need the value to be dynamic, I utilized the "calendar table" in the ALL SELECTED, and it works for dates, but when I changed the dates for months it's still showing the max per date instead of month, how could I modify this automatically? I want the max value for the current filters and columns I have in the table visual, not only for dates (daily)