Forum Discussion
Solved
First occurrence in a measure
Hi folks, I've been scratching my head over this issue and read through multiple forum posts but nothing has helped me so far. Sample data below: I have four fields here: Index - unsummar...
apurva989 , based on this ( if ([Cumulative Sum] >= [Wafer Sum], "Yes","No") ) , it should be like
minx(filter(values(Table[Index]), [Cumulative Sum] >= [Wafer Sum] ), [index])
You yes condition should be in the filter
amitchandak
Super User
Super Userapurva989 , based on this ( if ([Cumulative Sum] >= [Wafer Sum], "Yes","No") ) , it should be like
minx(filter(values(Table[Index]), [Cumulative Sum] >= [Wafer Sum] ), [index])
You yes condition should be in the filter
Thanks! I got the correct answer after I added the underlying filters 🙂