Forum Discussion

apurva989's avatar
apurva989
Frequent Visitor
5 years ago
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...
First Value
Flag
Measures to filter out
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

apurva989's avatar
apurva989
Frequent Visitor
5 years ago

Hey @amitchandak Almost there! 

 

Your formula does give me an index value but I'm looking for the first index value where the flag is yes. The value I'm getting right now is Index = 2. Should be 25. No percentile, just a plain lookup against the index column.

 

The flag measure I created is using the following formula: 

if ([Cumulative Sum] >= [Wafer Sum], "Yes","No")
 
Thanks for your help!
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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

  • apurva989's avatar
    apurva989
    Frequent Visitor
    5 years ago

    Thanks! I got the correct answer after I added the underlying filters 🙂