Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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%
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%
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |