issue with parameter formula page 141
Posted: Thu Aug 08, 2019 12:36 pm
The measure presented on page 141 for the Total Margin with Selected Increase did not work at all as described. I followed instructions to the "t" but my slicer did not cause the measure to recalculate the Margin. The column where I dragged this measure shows $4,072,733, i.e. the original margin coming from the source table. has anybody experienced a similar problem?
Re: issue with parameter formula page 141
Posted: Thu Aug 08, 2019 1:24 pm
Have you defined the measure [Selected Value] correctly?
Selected Value = MAX(Increase[Value])
Increase is the table with the values in Slicer.
First check that your measure [Selected Value] is working correctly.
Then use it in defining the measure
Total Margin with Selected Increase = [Total Margin $] * (100 + [Selected Value])/100
This works as expected.
Please check at your end and let me know if you still face the problem.
It would be of help if you can share the formulas you have written and a screenshot of the pivot table / visual.