Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance 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
User | Count |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |