The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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