Including the filter when summing the numbers in the column.

[Sammy_voi]

Hello, community. I need a little help. I have 5 columns, one is the column with the texts, the other 4 are numbers. I'm doing the sum of the numbers. However, when I do text filtering using text filter-contains, I still get the sum in all columns.

As I shared in the screenshot, the totals should be 0, but it gives values as if the filter wasn't applied.

Like this, but after filtering it should be 0

Using this: 

Retweet = CALCULATE(SUM('1'[retweet_count]))

[bolfri · Accepted solution]

Filtering the table in the "Data" view do not affect the vizualization. You need to apllay that filters on the Report page eg. in the Filter Pane.

[Sammy_voi]

Thank you Bolfri. I couldn't find it for 3 days, internet search. It's pretty obvious that I'm a beginner.