Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

KPI showing different data

Hi!

 

Can somebody please help me with this?

 

I have some data that I want to show with a KPI and that is not working.

I have 3 measures to make this work. The measures are:

 

YTDUSD:

CALCULATE(
	DIVIDE(		
		SUM(
			'Ventas'[USD]
		);
		1000
	); 
	USERELATIONSHIP(
		'Ventas'[Fecha]; 
		'Fecha'[Fecha]
	)
)

 YTDUSDAA:

CALCULATE(
	DIVIDE(		
		SUM(
			'Ventas'[USD]
		);
		1000
	); 
	DATEADD(
		Fecha[Fecha];
		-1;
		YEAR
	); 
	USERELATIONSHIP(
		'Ventas'[Fecha]; 
		'Fecha'[Fecha]
	)
)

Crec.YTDUSD 2:

IF(
	AND(
		'Ventas'[YTDUSD] <> 0;
		'Ventas'[YTDUSDAA] <> 0
		);
	(
		('Ventas'[YTDUSD] / 'Ventas'[YTDUSDAA])
		-1
	);
	0
)

 

When showing this measures in a table visual, I see the expected values:

But when using Crec. YTDUSD 2 in the KPI, the final value is complete different:

 

The KPI configuration is:

 

What can I be doing wrong?

 

Thanks in advance.

  • KPI is showing the latest value of "fecha" (date) in CREC YTD in KPI.

     

    In order to verify it, either include Date in your table Visual or Export data from KPI visual. You will see the last date will have CREC value of 29.6%

2 Replies

  • KPI is showing the latest value of "fecha" (date) in CREC YTD in KPI.

     

    In order to verify it, either include Date in your table Visual or Export data from KPI visual. You will see the last date will have CREC value of 29.6%

    • Anonymous's avatar
      Anonymous
      Not applicable

      Many thanks FarhanAhmed1984 for your reply!

       

      That's correct, it was showing las value. What I did, is not to use the date as tendance but the year itself. That way I get what I needed.

       

      Have a great day!