How do I highlight the last point in a dot-plot?

[DMilardo]

Hi, I want to highlight the last value of a point in a dot-plot. The last point has the biggest result_id in the table.

I have a static table which gets new values every day. It has four columns: result_id, result_value_x, result_value_y and machine_classifictaion. The mchine_classification has a 0 or a1 which i use in the dot-plot as a legend. My idea was to create a new dynamic column which gives changes the value in machine_classification to 2 for the last result_id in the table. 

I get the last value in a measure which value changes based of interactions on the foil. But if I want to create the new column every row has a 2. I don't know how to change the DAX-Calculation so it's changes when I get new result_id's in my table and by filters on my foil.

[mahenkj2]

Hi @DMilardo ,

I used a similar dataset:

new_classes is a calculated column which is same as what you intend to do, using following formula:

new_classes = if(scattertable[result_id]<>MAX(scattertable[result_id]),scattertable[machine_classification],2)

If you use this column as legend, following chart is achievable:

Hope it helps!

[DMilardo]

Hi @mahenkj2, thx for your response.

That's similar to one of my tries. 
The problem is when I filter the result_id's ,with for example a time-filter for a period of time, I get the wrong result_id. So the 2 ist static conected to my last result_id and not interactive to my filters on a foil. I tried to fix that with a measure which determines the last result_id but I get a column with a 2 in every row. 

Do you know a other way so I get a dynamic column for a dynamic legend?