Visual on drill through not returning what I expected

[pjandliz]

Hi

I have a relatively simple data model and am using some cascading drill through pages with.

I have a primary page/visual from which I drill into a 2nd page (using a person's Name), and on the 2nd page's visual drill into a 3rd (using an Opportunity #).

My problem is whilst my drill through column from page 2 to 3 is a single column, the page 3 visual seems to be filtered by the page 2 drill through.

I've built an example PBIX file - I've stored it on my GoogleDrive here.

The measure I'm displaying in the page 3 visual attempts to show a breakdown of the Opportunity value by Person (the value is attributed to) but I only seem to get the drill-through Name in the results.

I think I have the measure giving the correct value per person, but it only displays the one person.

I'm hoping it's just something simple I'm missing which will be easy to spot.

Thanks in advance. 

[lbendlin]

You can actually specify which filtering behavior you want.

[pjandliz]

Hi Ibendlin

Sorry, this doesn't change things. I only want the OppId filtering my measure.

Looking into this a bit more, my feel is the problem is the value measure in the chart - it only returns a value for the owner of the opportunity.

My measure is calculated as:

TotalReceivedForChart =

VAR Opp = SELECTEDVALUE(Opportunities[OppId])

RETURN

CALCULATE(

   SUM(Allocations[ReceivedAmount]),

   FILTER(

      Allocations,

      Allocations[OppId] = Opp

   )

)

I've added a table to show the data available to the measure and the results from the measure (see pic) - the measure needs to return the values of 100 for the cells under the blue box - I think once I can get this to work then the chart will give me what I'm after.