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.

 

Green Indicator= If is not blank [measure], [measure] > [measure1] then 1 else 0

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello @JCK2 ,

    Check

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

    Best regards

    Jay

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    @JCK2, try DAX

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello @JCK2 ,

    Check

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

    Best regards

    Jay