Forum Discussion

sudheer348's avatar
sudheer348
Regular Visitor
3 years ago

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...
Need Help
Show and Tell
Tutorial Requests
sudheer348's avatar
sudheer348
Regular Visitor
3 years ago

Updated the sample Data Link now and it should not ask for login. thanks for catching it!

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    a) 

    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?