Forum Discussion

Sowmiya's avatar
Sowmiya
Icon for Helper III rankHelper III
7 years ago
Solved

DAX Formula

  Hi Community, Help me with DAX that returns the Largest S.NO's Corresponding Description but Description must be nonblank. In the Screenshot, DAX must return Animal. S.NO - 6 is Largest but ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • themistoklis's avatar
    themistoklis
    7 years ago

    Sowmiya

     

    This will give you the highest value:

     

    Highest Value = LOOKUPVALUE('Table'[Description],'Table'[S.NO],CALCULATE(MAX('Table'[S.NO]), 'Table'[Description] <>""))

    I

     

    It also works when you have multiple categories. Image below:

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

Sowmiya

 

This will give you the highest value:

 

Highest Value = LOOKUPVALUE('Table'[Description],'Table'[S.NO],CALCULATE(MAX('Table'[S.NO]), 'Table'[Description] <>""))

I

 

It also works when you have multiple categories. Image below: