PowerPivot formula on a new measure using cell value

Hi All,

I am using PowerPivot to create a report from a ZAP datacube.  
The information that I have brought into the 'Powerpivot Window' is stuff like -
Sales,  GP,  State,  Month,  Year

I am looking to create a measure that will allow me to divide the GP by a cell value - sort of like this
=Query[MeasuresGross Profit]/p4
(where cell p4 contains the trading days gone in the current month)

Unfortunately the error I get is "Failed to resolve name 'p4'. It is not a valid table or a function name."

Can someone please tell me how to perform calculations on measures against cell values


Who is Participating?
If the cell is populated from Power Pivot you can reference that Data
=Query[MeasuresGross Profit]/[MeasuresCost]

or something along those lines
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.