Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter a table by highest column value

Hello!   I have a dataset that is looking something like this:   Server Scanid Server1 1 Server2 2 Server3 1 Server1 3 Server2 3 How can I make a DAX query the o...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

Please check the below, whether it is what you are looking for.

 

 

ScanID Measure =
VAR lastscanidoverall =
MAXX ( ALL ( 'Table' ), 'Table'[Scanid] )
VAR currentscanid =
MAX ( 'Table'[Scanid] )
RETURN
IF (
ISFILTERED ( 'Table'[Server] ),
IF ( lastscanidoverall = currentscanid, currentscanid )
)

 

 

https://www.dropbox.com/s/093gm8gkoidowoq/anthon.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM