Current Ratio For previous year is calculated is Blank

[Anonymous]

Hi !
I have calculated a current ratio for Balance sheet in which when i take the diffrence for CY vs LY then if any filter or slicer is not applied values seems to be perfect but when the year is filtered from the sliceer the previous year Value go Blank and the difference value appears to be wrong .

Please help as soon as Possible.
Attaching my code here.
For Total current Asset = 

For Total Liability = 

For Current Ratio = 

For Current Ratio PY= 

This KPI is Going blank as soon as i toggle years from the date slicer.
Because of this all other kpi is hampered.
Please help urgent ..
Thank You in advance.

[mh2587 · Accepted solution]

Wrap the date table with ALL Function