issue with parameter formula page 141
-
- Posts: 1
- Joined: Thu Aug 08, 2019 12:18 pm
issue with parameter formula page 141
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
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
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
Ramana Varanasi
Training and Office Manager
Excelerator BI Pty. Ltd.
Training and Office Manager
Excelerator BI Pty. Ltd.
Return to “Help with the Book "Learn to Write DAX"”
Who is online
Users browsing this forum: No registered users and 1 guest