Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
Can someone explain this? Below are two tables, both are filtered by 2 same Transactions. The first table shows the Adjustment break down correctly, however the second table doesn't do the sum aggreagate correctly.
Exit Warehouse Date resides in a same table. Adjustments is a column and I'm doing aggreagate function (sum). I also created a quick measure (Adjustments) but it shows same incorrect numbers.
Items Sold table has no other dependencis. It's completely independent.
Hi @Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to OneDrive and share the link here.
@Anonymous
The first table is driven by warehouse exit date. Is it possible that you have additional dates? Or is warehouse exit date reside in a different table than adjustments?
Is adjustments a direct summation or a DAX measure? please post the DAX ..
If it helps mark it as a solution
Kudos are nice too
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |