Forum Discussion
KPI visualization - incorrect distance between indicator and target
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?
2 Replies
cahnge MAXX > MAX & MINX > MIN hope it will work
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:
