Forum Discussion

christinas's avatar
christinas
Helper I
7 months ago
Solved

KPI showing incorrect target value

Hello. I have two tables I am working in; one is data for June 2024 and the other is for June 2025. They both have the same type of data just for two different years. For 2024 I have 79,322 unique values for ID. For 2025, I have 81,515. The Target is the 2024 (79,322), the Value is the 2025 (81,515) and the Trend axis is the Survey Completion Date of 6/1/2025 from the 2025 table. 

The issue I have is the 2024 target is showing 79,023 instead of 79,322. I can confirm both sheets have the correct total number of IDs and there are no duplicates. I've tried to use the 2024 Survey Completion Date but it does not change the total number. Any change I make (including creating another table for the dates) does not solve the issue and removes the trend chart. I also tried using countrows instead but it didn't change the outcome. The issue seems to be with the 2024 totals. Does anyone know why I am having this issue and how I can fix it. 

 

DAX: 

2024_Count EE = COUNT('2024 Respond Demo'[EEID])
2025_Count EE = COUNT('2025 Respond Demo'[employee_id])
Thank you,
Need Help

6 Replies

  • v-hashadapu's avatar
    v-hashadapu
    Community Support
    6 months ago

    Hi , It’s been some time since we last connected. We’re ready to assist you in resolving your issue, but we’ll need the necessary details to continue. Please share the necessary information and we’ll try and help you.

  • GeraldGEmerick's avatar
    GeraldGEmerick
    Super User
    7 months ago

    christinas Perhaps try something like the following:

    2024_Count EE = COUNTROWS(ALL('2024 Respond Demo'))

or

2024_Count EE = COUNTROWS(ALLSELECTED('2024 Respond Demo'))
  • v-hashadapu's avatar
    v-hashadapu
    Community Support
    7 months ago

    Hi christinas , Thank you for reaching out to the Microsoft Community Forum.

     

    To understand and answer your issue completely, please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Include all the necessary details, detailing your scenario and issue as clearly and fully as possible. 


    Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

    Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    6 months ago

    Hi christinas,

     

    Just checking in! We noticed you haven’t responded yet, and we want to make sure your question gets fully resolved.

    Let us know if you need any additional support.

    Thanks again for contributing to the Microsoft Fabric Community!