Forum Discussion
First occurrence in a measure
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
Super Userapurva989 , Try a measure like
minx(filter(values(Table[Index]), [Cumulative Sum] >= [Wafer Sum] * 0.5), [index])
Or are you looking for percentile?
example
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
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:
- amitchandak
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
Thanks! I got the correct answer after I added the underlying filters 🙂