Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter using measure

Hello All,

 

Need help in undestanding the filter function and apply for my use case.


I have 2 months of sales data (Jan and Feb) having both postive and negative values (for few rows) and i want to filter the visual to show rows having positive values only.

However, issue pops up in cases where Jan month is +ve and Feb month is -ve or vice-versa.

 

In short, how can i apply sales measure as a filter and show only +ve rows and apply across any/both months.

ignore rows where it has got both +ve and -ve values in the different months.

 

Please help.

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    You can try.

     

    Measure = If ([Sales] > 0 , [Sales] , BLANK())

     

    Also,

     

    You can create a Visual Filter

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    You can try.

     

    Measure = If ([Sales] > 0 , [Sales] , BLANK())

     

    Also,

     

    You can create a Visual Filter

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

     

    Can you upload the data in One Drive / Google Drive and share the link. 

     

    Also for the sample data what is the ouput expected.

     

    Best Regards

     

    CheenuSing

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , You can create a positive measure like

    sumx(table, if(table[value] =abs(table[Value]),Table[Value]))