Forum Discussion

Euro0681's avatar
Euro0681
Helper II
3 years ago

Calculation With Filters

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"}) 

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Euro0681 

    Are you sure they are the same? If you mean the first two rows in your screenshot, I see two different IDs.

    • Euro0681's avatar
      Euro0681
      Helper II
      3 years ago

      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?