issue with parameter formula page 141

A dedicated forum to help people when working through the book "Learn to Write DAX"
odell_olga
Posts: 1
Joined: Thu Aug 08, 2019 12:18 pm

issue with parameter formula page 141

Postby odell_olga » 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?

RamanaV
Posts: 36
Joined: Thu Oct 19, 2017 12:57 pm

Re: issue with parameter formula page 141

Postby RamanaV » Thu Aug 08, 2019 1:24 pm

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
Ramana Varanasi
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