Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter table by highest value

My table is like this I want to filter the table by the highest [ Rec] value as follows  
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on your description, you can create a measure as follows.

    Measure = 

    var x1=MAXX(FILTER(ALL('Table'),[Custld]=SELECTEDVALUE('Table'[Custld])),[Rec])

    return

    IF(MAX('Table'[Rec])=x1,1,0)

    Then you can drag it to the filter of the table visual you created and select "value=1".

     

    Result:

     

     

     

     

     

     

     

     

     

     

     

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

Sorry, I'm cannot see the criteria by which the values are filtered. Can you explain further please?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PaulDBrown 

It should be based on "Rec" column. For an example, customerId 789 has four rows of data, among them I want to get the highest "Rec" number containing row which is number 4.