Forum Discussion
Visual on drill through not returning what I expected
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 ...
lbendlin
Super User
Super UserYou can actually specify which filtering behavior you want.
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.