Forum Discussion

AndreiK15's avatar
AndreiK15
Icon for Helper II rankHelper II
4 years ago
Solved

Wrong Sales values when apply Filters on this visual

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: ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

AndreiK15's avatar
AndreiK15
Icon for Helper II rankHelper II
4 years ago

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 🙂