Forum Discussion
Write a Measure to retrieve a Column Value based on other measure filters
Hi, I am drawing a Line chart with x-axis as Date and Y-axis as Percentage and would like to draw a vertical line (date) where i hit first 0 for "Remaining" or "Percentage" [ ideally both are s...
Updated the sample Data Link now and it should not ask for login. thanks for catching it!
lbendlin
Super User
Super Usera)
First Zero Date =
var a = summarize(ALLSELECTED(Data),Data[MaxDate],"pc",min(Data[Percentage]))
return minx(filter(a,[pc]=0),[MaxDate])b)
Show = if(max(Data[MaxDate])<=[First Zero Date],1,0)
not sure what you mean by c) - Divide Remaining by Percentage should give you the full value?