Aggregation Error

[kharigardnerpdl]

Hello!

I have a sales fact table which list sales by id, income date, and income amount. I am plotting said columns in standard bar charts available with PowerBI. However, the visualizations show incorrect aggregations. I am able to get the correct aggregations in Power Query and directly in SQL, along with pandas, but here it is completely incorrect. Any ideas? I have followed all data model best practices, one way filtering, one to many relationships, but nothing is pointing to what could be an error?

[Shaurya]

Hi @kharigardnerpdl,

Please check if there isn't any filter on the visual for current month related numbers. Check for any filter context that might be applied on the measures for calculating these numbers.

Mark this post as a solution if that works for you!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI