Wrong Sales values when apply Filters on this visual

[AndreiK15]

Hello,

I need to get known losses (%), but if I set Filters on this Visual for Known Losses Amt AY to “is not blank”, I get a wrong result.

Without Filters on this Visual I get the following:

All figures are correct, the only issue is that it returns all blanks rows because there is a value in Target column.

If I set Filters on this Visual for Known Losses Amt AY or any other Losses Column to “is not blank” it will return all losses (correct values), but it will return wrong values for sales (will return only sales for those articles with losses).

I need to return sales values like in the first picture when apply Filters on this Visual, but need to keep figures just for Level 1 and total for Store (Store – 69.597, PROASPETE – 27.871 and so on… ).

I have tried all filter functions so far, but something’s wrong … relationships between tables are correct.

Please help!!!

Thank you!

[AndreiK15]

I have created a new measure for target (%) and target (val) column with a filter and works fine now. I wasn't paid attention to that at the moment. Thanks for opening my eyes 🙂 

[AndreiK15]

I believe it's a column measure since it was added on Filters on this viasual...

[amitchandak · Accepted solution]

@AndreiK15 , you applied a measure filter or a column filter. Column filter can remove row-level data , Measure filter will remove visual level data.

I think in this case you need a measure filter at visual level