slicer powerpivot

Hello, I searched the forums but haven't seen this issue yet... When using cube formulas that are driven by measures and cubesets driven by formulas, I receive the #N/A error when I deselect from a slicer. This is generated because the cubeset formula for that slicer throws an #N/A... Has...

Hi all, I have two data tables: 1) Production data with column headers: Key, Facility, Line, Time, Output 2) Costs data with column headers: Key, Site, Cost Center, Time, Cost The tables have a common key named obviously as Key. The data looks like this: Key Facility Line Time Output Alpha...

Hello, this is my first post, hopefully someone will be able to help. I'm having some issues in automating a PowerPivot slicer using vba. What I am trying to do is have the slicer update and only select what is in a certain cell. So for example assuming the cell was A3 then whatever was typed in...

Hello, I have a "Measure" slicer that allows you to select either Nominal, YoY Growth %, or 5yr CAGR %. I then have a DAX measure that calculates based on what is selected in the "Measure" slicer: Measure Type = IF([isReportSlicerSet],SWITCH(VALUES('Measure'[Measure]),"Nominal",[Total...

Hi all,My question is that I try to retrieve the values ​​of a filter from one workbook 'A' and pass them to another excel workbook 'B'. is it possible with PowerPivot? (is there a solution that allows us to generalize a filter between two folders??)</pre> i've excel pro 2013.th'ks a lot for...