Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Having an issue, the image on the left shows a calculation of sum and the image on the right shows same sum as well
the only difference the calculation on the left has filters applied as a visual filter and the calculation on the right has the same filters applied inside the calculation.
Not understanding why it repeats the the first ID twice??
Calcualtion W/Filters:
Calculate(Sum('Table1'[Sales]) , 'Table1'[Sales] > 0, 'Table2'[Date] in {"2020 - 01","2020 - 02", "2020 - 03"})
hi @Euro0681
Are you sure they are the same? If you mean the first two rows in your screenshot, I see two different IDs.
@FreemanZ well not identical but on the screenshot in the right the id starting with 3 has an additional value "340.00" which wasn't in the left screenshot but left image has same filters applied on a visual level and the one in the right has it in the calculation so why the additional value?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |