I have prolem while referring a measure in other measures. When I referred to the value of 1st measure in the second measure, it does not stay static. However, I need it to be fixed for further calculation.
The structure is like following.
Table 04 includes revenue data per date per product;
Table 08 includes sessions per date per product;
(please note that table 04 & table 08 are not directly related)
Table Date includes date;
Table 24 includes cost per date per campaign.
My objective is to calculate the ROI per product (with a date slicer), which includes 2 steps:
1) Calculate the cost per session (I assume the cost per session is the same for each product at a selected time period)
Measure 1 =
2) Divide the revenue by number of sessions and cost per session
Measure 1 works fine itself. However I could not get the correct value from Measure 2. It does return values, but none of them are correct. Then I divided the Revenue by number of sessions and calculated ROI (which is the value of Measure 2), and found out that the number differs for each product.
I have been stuck on this problem for hours and still could not find a way to fix it.
Difficult to say exactly given the information but you will need to create a table context for your 1st measure within your 2nd measure that "fixes" the calculation to what you want. You don't really specify what context that is though. Sounds like you need to do a SUMMARIZE by product and then add in your measure to the end of that and then use a FILTER to grab the correct line from your table.
Did I answer your question? Mark my post as a solution!