How to get the values correct in the KPI Cards?

[Anonymous]

Hi

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

Total leads = COUNTROWS('pack Unpacked')

Total Leads LY = CALCULATE([Total leads], SAMEPERIODLASTYEAR('Date'[Date]))

I am showing total leads and total leads ly in the KPI Chart. The values are coming correct if I select the particular year, however, when I select more than one year the values are not matching in the KPI visuals.

Values are correct when I show for a particular year

Values are not matching when I select 2019 data,

I need to get 20201 in the KPI visuals, previous year showing correct. How to fix it. Basically, I need to get values in the KPI card based on any date selected. Is there any way?

Attach my PBIX file here

https://we.tl/t-xLXY5Hgr1z

Please advise

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

You can try measure as:

Total leads = CALCULATE(COUNTROWS('pack'),ALLEXCEPT('Date','Date'[Date]))

Total Leads LY = 
CALCULATE([Total leads],SAMEPERIODLASTYEAR(ALLSELECTED('Date'[Date])))

 Here is the output:

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

@m3tr01d @Anonymous @Syndicate_Admin  Thanks for your reply. There are no visual filters on the table or KPI card. If I select the date for one year, the values are showing correctly. Not showing for multiple years

[Anonymous]

Please share PowerBI file if you can

[Anonymous]

@Anonymous Thanks for your support. Please find the pbix file

https://we.tl/t-xLXY5Hgr1z

Kindly check and advise. Thanks

[Syndicate_Admin]

According to I see, the KPI is not being affected by the filter that comes from the date, have you seen that part?

[Anonymous]

Hello @Anonymous ,

Please check if there is any duplicates, visual filters, page level filters and compare yearwise data in a table. 

This is the only rootcause you can do why the sum is not coming correctly. As you have not created any measures mostly it would be the data issue.

Thanks,

Karthik

[m3tr01d]

Hello!
are you sure you don't have any visual filters on the table or on the KPI card?