Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
11 | |
11 | |
8 | |
8 | |
8 |