Page 1 of 1

issue with parameter formula page 141

Posted: Thu Aug 08, 2019 12:36 pm
by odell_olga
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
by RamanaV
Hi,

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.

Thanks