Forum Discussion
Filter table by highest value
My table is like this
I want to filter the table by the highest [ Rec] value as follows
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.
4 Replies
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.
Anonymous
Sorry, I'm cannot see the criteria by which the values are filtered. Can you explain further please?
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.
Hi,
Do you want the result using the Query Editor or using measures in a visual?
