cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OlegV
Helper I
Helper I

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.

OlegV_1-1632386113237.png

OlegV_8-1632386564042.png

 

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

OlegV_14-1632387568590.png

 

 

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

 

OlegV_4-1632386296915.png

 

OlegV_5-1632386318400.png

 

OlegV_0-1632388074937.png

 

OlegV_9-1632386601256.png

 

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

 

2) So I changed DAX:

OlegV_10-1632386718499.pngOlegV_11-1632386741701.png

 

KPI shows a difference = 0.

OlegV_12-1632386775781.png

 

 

Where is my mistake?

2 REPLIES 2
mh2587
Post Patron
Post Patron

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

Thank you.

1) It DID NOT work:

OlegV_0-1632404495065.pngOlegV_1-1632404510974.png

 

OlegV_3-1632404598732.png

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:

OlegV_0-1632840578163.png
But the Indicator measure detects the last day automatically:
OlegV_1-1632840914578.png

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors