When you divide any number by zero then it will give you nothing, Actually zero can't divide any number.
Please let me know if you have any question.
Please mark correct and helpful if it works for you.
You are close! You just need to change your LOD to use [Segment] instead of YEAR:
You can also do this with Table Calculations:
The workbook is attached.
Hope this helps!
Ratio_v10.2.twbx 2.4 MB
Both measures have values in them. So if i divide them with each other shouldnt be 0 right ? Or am i missing something?