CUBEVALUE returning blank

=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Path PP Plan Yes]", "[Path].[Pathway Plan].No", "[Service Areas].[Service Areas].["&A56&"]") = returns blank

=CUBEVALUE("ThisWorkbookDataModel","[Path].[Pathway Plan].No", "[Path].[PP Eligible for Plan].Yes", "[Service Areas].[Service Areas].["&A56&"]") = returns blank

=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Path PP Yes Plan No]", "[Service Areas].[Service Areas].[&"A56&"]") = returns blank

=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Path PP Plan Yes]", "[Measures].[Path Plan No]", "[Service Areas].[Service Areas].["&A56&"]") = returns #VALUE

Background info :

[Measures].[Path PP Plan Yes] = [Path].[PP Eligible for Plan].Yes
[Measures].[Path Plan No] = [Path].[Pathway Plan].No
[Measures].[Path PP Yes Plan No] = [Path].[PP Eligible for Plan].Yes and [Path].[Pathway Plan].No

There are two columns in my table. Both of them have various Yes and No's - [Measures].[Path PP Yes Plan No] returns 20 in PowerPivot.
DAX formula : Path PP Yes Plan No:=CALCULATE ( COUNTROWS ( 'Path' ), FILTER('Path','Path'[PP Eligible for Plan] = "Yes"), FILTER('Path','Path'[Pathway Plan] = "No"))

There should be figures returning and have no idea why this is the case.
I have checked data in [Service Areas].[Service Areas] and I am able to find matching data in Path table.

If anyone can help that would be great. I am fairly new to CUBE formulas so if an explanation could be given along with the answer, that would be amazing.

Thank you in advance.

Fixed the formula but not in the way I wanted to.

=CUBEVALUE("ThisWorkbookDataModel",$A54,"[Measures].[Path PP Yes Plan No]")
A54 : =CUBEMEMBER("ThisWorkbookDataModel","[Path].[Service Area - TRUE]&[Support Service]")

Originally A54 was =CUBEMEMBER("ThisWorkbookDataModel","[Service Areas].[Service Areas].&[Support Service]")

As mentioned before, the original formula for A54 worked for other CUBEVALUE formulas but not sure why, on this occasion it failed....