Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Goal value is not matching in the KPI card?

Hi

 

I created two measures called total leads and total leads ly (previous year)

 

Total leads = COUNTROWS('pack Unpacked')
Total Leads KPI = CALCULATE ( [Total leads], ALLSELECTED () ) (I got this from yesterday's post in the communityhttps://community.powerbi.com/t5/Desktop/Not-getting-the-correct-values-in-my-KPI-Card/m-p/1904891)
Total Leads LY = CALCULATE([Total leads], SAMEPERIODLASTYEAR('Date'[Date]))
 
I am showing total leads KPI and total lead ly in the KPI Chart.
 
jason2000_4-1623987817590.png

 

 
The goal values are not matching if I slide multiple years in the date slicer.
jason2000_5-1623987874461.png

 

Could you please advise me what is the error?

 

Attach my PBIX file here

https://we.tl/t-XVBf3wDjKB

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@Anonymous 

 

Try change it to:

Total Leads LY = CALCULATE([Total Leads KPI], SAMEPERIODLASTYEAR('Date'[Date]))
 
 
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

@Anonymous 

 

Try change it to:

Total Leads LY = CALCULATE([Total Leads KPI], SAMEPERIODLASTYEAR('Date'[Date]))
 
 
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.