=CUBEMEMBER("ThisWorkbookDataModel","[Measures].[Average of Order Amount]")
=CUBEVALUE("ThisWorkbookDataModel","[Regions].[ProvinceID].["&$B34&"]","[Dates].[MonthName].["&C$33&"]",$B$31,Slicer_Year_12)
where C$33& = "Jan"
When I recreate the same senerio without pivot table just using manage data model and i create my own measure Average of Order Amount the cube formula
does not work is that because pivot table has a built in filter and my measure needs to include a filter?
this is my measure:
Average of Order Amount:=AVERAGE([Shipping Amount])
Hi Bill,
I suspect it's something else because you can create your own measure, but you might want to give it a different name to the implied measure name. e.g.instead of Average of Order Amount, try Avg Order Amount.
It's difficult to say more without seeing the whole picture. Are you able to share your file?
Mynda
I figured it out because i created my own measure i had deleted the implied measure which caused the issue now it working thank you
