SalmonEggs
New Member
- Joined
- May 19, 2014
- Messages
- 2
I'm looking for some insight on a PowerPivot problem that's got me tied in knots. I'm finding that whenever I use a filter within a measure the resulting detail report (generated by double clicking on a value in the pivot table) does not reflect the filter.
As an example, lets say I have a list of three names {Paul, Ted, Sue} each of which are also indicated to be either male or female. Let's assume for the sake of this simplified example a slicer for male or female is not an available option. So I create a measure which is something like [Count Male]:=calculate(countrows[<wbr>table1],table1[gender]="Male") the result displayed in a pivot table if I drag this measure to the values column would be 2 assuming Paul and Ted are male and Sue is female. However, when I click on the value to see the underlying records for Paul and Ted, I get rows for Paul, Ted, and Sue.
So my question is how to go about applying a filter within a measure that also is correctly reflected on the detailed reports? I've been digging around on the web for several days now but have not been able to find anything that specifically addresses this issue. Any help would be appreciated.
As an example, lets say I have a list of three names {Paul, Ted, Sue} each of which are also indicated to be either male or female. Let's assume for the sake of this simplified example a slicer for male or female is not an available option. So I create a measure which is something like [Count Male]:=calculate(countrows[<wbr>table1],table1[gender]="Male") the result displayed in a pivot table if I drag this measure to the values column would be 2 assuming Paul and Ted are male and Sue is female. However, when I click on the value to see the underlying records for Paul and Ted, I get rows for Paul, Ted, and Sue.
So my question is how to go about applying a filter within a measure that also is correctly reflected on the detailed reports? I've been digging around on the web for several days now but have not been able to find anything that specifically addresses this issue. Any help would be appreciated.
