Forum Discussion
Helper ICalculation not working when slicers applied
Hi jmorela1 ,
You must add a new measure that is the cost per google for or whatever other name you want to give it and di the division of both the measures you refere:
Has you can see on my image the measure for the division between both of this values gives the correct value:
In the file I have shared search for the measure Cost per google form and use it on the matrix you should get the correct value.
Community SupportHi jmorela1 ,
If you get a chance to review my previous response, I hope it is helpful. Please take a moment to check it and let us know if you need any additional details or clarification.
Thanks.
Helper INone of the solutions offered has fixed the cost per form complete specifically, when both a Subset BU and Channel are selected
- MFelix
Super User
Hi jmorela1 ,
Is the calculation that you need to do the value on the column Cost per Google Form Complete?
If this is the case you will never get the correct value since you are using measures to calculate a column and since meaures are context dependent when you add them to a column the result will be incorrect.Have you tried the measure:
Cost per google form = DIVIDE([Total Spend Measure],[Total form completes measure])Can you explain better what is the value you want to achieve. In the file you share there is only one BU so is difficult to give the correct syntax.
- jmorela1
I have, and it is still not correct when both a Subset BU and Channel are selected.
- MFelix
What is result you are expecting?
Can you give an example of the exact value? Further more has I have refered in the example you provided there is only a single subset BU and Channel we cannot apply any filters that returns different values since the subdataset is the same has the dataset.