Dynamically exclude blank values

Hello:

I'll try to explain by way of an example.

I have a table. Let's say I want to Divide the start value by the end value to make an index.

Because I have a couple of zero values , I don't want to include these. So I make two measures for start and end that avoids these 0's.

Start Amt = CALCULATE(SUM(Divide_Table[Start]), FILTER(Divide_Table, Divide_Table[Start] <> 0 && Divide_Table[End] <> 0))      

End Amt = CALCULATE(SUM(Divide_Table[End]), FILTER(Divide_Table, Divide_Table[start] <> 0 && Divide_Table[End] <> 0))

 

Now I can use divide function to ignore any possible zero's and summing errors:

Final= DIVIDE([Start Amt], [End Amt],0)

 

the result ignores the incomplete values: