Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?