Filter table by highest value

[Anonymous]

My table is like this

I want to filter the table by the highest [ Rec] value as follows

[Ashish_Mathur]

Hi,

Do you want the result using the Query Editor or using measures in a visual?

[Anonymous · Accepted solution]

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]

@Anonymous 

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

[Anonymous]

@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.