What is the condition to Find the lowest values in column and extract them from similar values with another column

[Izzat_Safrah]

What is the correct way to make a condition in the wnidow Format rules for the column [PRICE].

The required condition is as follows:

Searching for equal values in the column [SIZE] & it should be lowest value in the column [PRICE].
The value that satisfy both conditions should be marked in red in the [PRICE] column.

Attached are picture for explain.

Data/Columns

UX/Format Rules

In the date entry page

[WillowMobileSys · Accepted solution]

Try this expression:

[Price] = MIN(SELECT(Market Surve[Price], [Size] = [_THISROW].[Size]))

[Izzat_Safrah]

@WillowMobileSystems I followed your instructions and are now working fine.

I’ve used the expression suggested by you in the window Format rules
[Price] = MIN(SELECT(Market Surve[Price], [Size] = [_THISROW].[Size]))

lowest value in the column [PRICE] it show red

Thank you very much