KPI visualization - incorrect distance between indicator and target

[OlegV]

Hello,

The KPI shows different disances when I automate indicator and target. But when I set them manually, it shows a correct distance. Please tell me where my mistake is. 

Input data:

I have a table with prices which update weekly. In KPI I need to show the last day price as an indicator and the first day price as a target. The KPI difference will be a subtraction between the last day and the first day.

There are also filters on this visual: a slicer " Delivery date" and a visual filter " Product used in charts"

1) in this measure I set dates manually and it shows the difference correctly:

But every week I need to enter new dates manually, so I decided to automate.

2) So I changed DAX:

KPI shows a difference = 0.

Where is my mistake?

[mh2587]

cahnge MAXX > MAX & MINX > MIN hope it will work

[OlegV]

Thank you.

1) It DID NOT work:

2) I noticed, that the difference is not calculated correctly, because Target measure cannot detect the last day automatically. Hence it must be written like this, manually:

But the Indicator measure detects the last day automatically: