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
Resolver I
Resolver I

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.