KPI Indicator

[JCK2]

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

[amitchandak · Accepted solution]

@JCK2, try DAX

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

[Anonymous · Accepted solution]

Hello @JCK2 ,

Check

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

Best regards

Jay

[amitchandak · Accepted solution]

@JCK2, try DAX

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