removefilters makes other row appears

[Broly221]

I have a table like this one: 

I have filtered it to get only data for 1 jan like this :

I have created a measure the removes the filter on the date : calculate(sum(Amount), removefilters(date))

because I want to know the total amont:

probleme is i get new rows like this :

but that's not what I want. I want to keep the number of rows that I got after filtering.

How can I do this please ? thanks

[v-jingzhang]

Hi @Broly221 

Is your expected result in a table visual? If so, you need to remove the [ref] column from the table visual, then you will find your [amount removefilter] measure works correctly. 

This is because when [ref] column is in the same visual, it will pass a filter to other columns, leading to change the result of measures. If you want to have [ref] column in the same table visual, you have to add [ref] column in REMOVEFILTERS function too.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.