Forum Discussion

Saipreethi's avatar
Saipreethi
Icon for Helper I rankHelper I
4 years ago

Removing Zero valued rows which are measures

Hi Everyone,

 

I have a table with Clients and sub category of Countries with all 15 measure columns. I want to remove countries which have zero values in all columns. Can anyone help with logic. I have implemented by taking every measure as Variable and applied "AND" condition between them and kept that column in table and applied visual level filter. But I am missing something in the above. Need help!

 

Need Help
Tips and Tricks

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Saipreethi Seems like:

    Flag = [Actuals] + [Budget] + [Delta] + [D] + [E] + [F] + [G]

    Then use the Filters pane to exclude where Flag = 0

    • Saipreethi's avatar
      Saipreethi
      Icon for Helper I rankHelper I
      4 years ago

      Hi Greg, Iam getting this error if I apply the above mentioned condition on visual level.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Saipreethi ,

         

        The error means one of the column in the formula have text value, please check the data.

         

        Best Regards,

        Jay