## Ch 16 Creating a Harvester Calculated Field

A dedicated forum to help people when working through the book "Learn to Write DAX"
Kelly
Posts: 1
Joined: Wed Oct 05, 2016 10:48 pm

### Ch 16 Creating a Harvester Calculated Field

I have followed all of the steps to create the Harvester for % increase but my Total Margin with Selected Increase always calculates a 15% increase--so it is not "harvesting" the selected value. Any ideas?
Harvester.JPG (49.57 KiB) Viewed 1356 times

[Selected Value]=MAX (Increase[Value])

[Total Margin with Selected Increase]=[Total Margin \$] * (100 + [Selected Value])/100

MattAllington
Posts: 914
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

### Re: Ch 16 Creating a Harvester Calculated Field

Hi Kelly, sorry I missed your post Last week. Everything I can see looks correct. Is the slicer connected to the pivot table? My guess is that it is not.
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

Sarmyles
Posts: 6
Joined: Mon May 30, 2016 7:02 pm

### Re: Ch 16 Creating a Harvester Calculated Field

Matt,
I had the same problem and your solution is correct - the pivot table was not connected. Why does this need to be done manually ?

MattAllington
Posts: 914
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

### Re: Ch 16 Creating a Harvester Calculated Field

If you first select a pivot table, then add a slicer (right click on the column in the field list and select "add as slicer") it will automatically be connected. If you have not selected the pivot table and you "insert slicer" from them menu, it will not be connected and you will have to connect it manually. It makes sense actually. If here are 5 pivots in a page and you add a slicer, which ones should be attached? It depends of course and his way you have control.
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax