Because you using the "based on Subtotal of column 'TotalPrice'"
you should be using the "Based on items with a specific column value" option.
lets use item ID 23 as an example calculation, lets say you want to offer 25% on Quantity 1 - 9 of item ID 23, the calculation settings should be:
Triggers:
"Presence of item in the cart"
If item '23' 'exists' in the cart
AND
"Quantity of a specific item in the cart"
If the quantity of Item '23' in the cart is '>=' a value of '1'
AND
"Quantity of a specific item in the cart"
If the quantity of Item '23' in the cart is '<=' a value of '9'
Calculation:
"Based on items with a specific value"
Total of "TotalPrice" where "ID" has a value of "23" "times" "0.25"