Forum Discussion

SteelChampzz's avatar
SteelChampzz
Icon for Helper II rankHelper 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
    tamerj1
    3 years ago

    Hi SteelChampzz 
    You can try

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi SteelChampzz 
You can try

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

SteelChampzz's avatar
SteelChampzz
Icon for Helper II rankHelper II
3 years ago

That worked PERFECTLY!

thank you