Forum Discussion

Broly221's avatar
Broly221
Frequent Visitor
3 years ago

removefilters makes other row appears

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), removefilte...
Need Help
Tips and Tricks
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

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.