Forum Discussion
Calculate value same column with condition
Hi all! I need to calculate the value of the state "in progress" for each ID by checking if the state column has "in progress" and "prioritized", otherwise I will not return anything. In this cas...
Thank you for the message, Anonymous.
RETURN IF((SEARCH("In Progress",_state,1,0) && SEARCH("Prioritized",_state,1,0)>0), _value,0)Best,
Paul
Hi, Anonymous
and Thank you Anonymous .
It should work properly with this DAX formula, you can try again or maybe figure around with the table visual.
Best,
Paul
Anonymous Not able to see your formula
But in above code instead of both of the search output greater than two each search output should be greater than zero.
Thank you for the message, Anonymous.
RETURN IF((SEARCH("In Progress",_state,1,0) && SEARCH("Prioritized",_state,1,0)>0), _value,0)Best,
Paul