Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help please! - Different average values for KPI and Card

Hi guys, 

 

I have a two part problem:

1. Why does the card and KPI visual differ when I use a measure based on a slicer? In below visuals, I filtered the date (date table) in the last 12 calendar months. Meaning Aug 2020 to Jul 2021. In the card visual it is 557.1. However, when I use the KPI (bottom image), the value is 342.9. The KPI is getting the latest value only. Do I need to compute a separate measure based on the date I selected? If yes, can you help with the formula?

 

Note: For the KPI, I used month year as the axis. For the date slicer, I used date. 

 

 

 

2. The average is 557.1. When I compute it in excel it is 581.2.  

 

Show and Tell
Tips and Tricks

4 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    5 years ago

    Try something like if your column Rental Avg is a measure

     

     

    _Average = AVERAGEX(Values(Table[Month Year]), [Rental Net (Avg)])

     

  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    Hey Anonymous ,

     

    please prepare a pbix file that contains sample, but still reflects your data model, upload the file to onedrive or drobox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

     

    Please create the visuals from the sample data.

     

    Regards,

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi TomMartens, I sent you the link of the file privately. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    I can't reproduce your problem, please check the below screenshot. And how did you get the average of Rental Net? Could you please provide the related formula and more example data(exclude sensitive data) in order to make troubleshooting?

    Best Regards