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 wan...
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)

     

     

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]))