Forum Discussion

JCK2's avatar
JCK2
Helper III
6 years ago
Solved

KPI Indicator

Hello,   Im looking to calculate an indicator, which says, if my measure is not blank ( first condition), then check if my measure is greater than target ( second condition), then give me 1 else 0....
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    @JCK2, try DAX

    if( not(isblank([measure])), if([measure] > [measure1], 1 , 0),blank())

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello @JCK2 ,

    Check

    Green Indicator= IF([measure]<>BLANK()&&[measure]>[target],1,0)

    Best regards

    Jay

amitchandak's avatar
amitchandak
Super User
6 years ago

@JCK2, try DAX

if( not(isblank([measure])), if([measure] > [measure1], 1 , 0),blank())