This topic contains 3 replies, has 2 voices, and was last updated by 
-
Posts
-
Hi
I encounter problem while creating “Harvester Calculated Field”. It is a terminology used in Matt Alington’s “Learn to Write DAX” book in chapter Chapter 16.
I followed steps mentioned in book but still not able to create that calculation.
Accoording to the book, should
1. Create seperate table with values
2. Find MAX of selected value and define it as a measure
3. Use that measure in required calculationCalculation made on maximum of additional table. It does not recognise the slicer selection.
I attach the file for detailed examination.
Please help me on this issue.
eisayev,
A tricky case! You have two pivots on one sheet, but the slicer is only controlling (connected to) one. Click in any cell of the larger pivot (pivottable2), then in the Pivot Table Tools context menu, under the Analyze tab, locate the Filter group and click on the Filter Connections button. When the Filter Connections dialog box opens, you will notice the checkbox to the left of “Values” is blank. After entering a check mark and choosing OK, your slicer will now control both pivots.
By default, slicers only affect the pivot where they were created. Controlling other pivots requires the steps above.
Slicer in attached workbook controls both pivots.
Tom
Tomallan,
Thank you very much.
In book the method you wrote did not mentioned. Almost 12 hours I am trying to figure it out. 🙂
Thank you again.
You’re welcome!
Tom
The forum ‘Power Pivot’ is closed to new topics and replies.