Forum Discussion

info_algoritmia's avatar
info_algoritmia
Helper II
2 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
    2 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
2 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>>
)
  • info_algoritmia's avatar
    info_algoritmia
    Helper II
    2 years ago

    parry2kdo you know any particular reason that this is working for weeks, year but not for months? It's not returning the max value for months