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
Go to Solution.
@JCK2, try DAX
if( not(isblank([measure])), if([measure] > [measure1], 1 , 0),blank())
View solution in original post
Hello @JCK2 ,
Green Indicator= IF([measure]<>BLANK()&&[measure]>[target],1,0)
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.