Forum Discussion

SteelChampzz's avatar
SteelChampzz
Helper II
3 years ago
Solved

How to filter dates with no values

I want to be able to add a filter to the measure so that any date that has $0, doesn't show. Or would it be easier for me to filter them in the visual, If so how would I do that? Thanks to anyone ...
  • tamerj1's avatar
    3 years ago

    Hi SteelChampzz 
    You can try

    Amount2 = 
    VAR Amount = [Amount]
    RETURN
    IF ( Amount > 0, Amount )