Hello all, I am trying to set up some measures that work with my hierarchy and report filters to show performance for hierarchy levels above when filtered - eg I select a store and see their performance, district performance, and Market performance as three different lines on a line chart. I have created measures that work perfectly when using crossfiltering with another visual on the report (a matrix), but they don't seem to work when simply using the filter pane. When I select the store in the matrix, the line chart filters to show me the three lines - store, district and market all with correct results. Oddly, when I filter to the store using the Filter Pane (Filter on All Pages), I only see two lines - store and market (the District measure now matches Market).
I'm assuming this has to do with how I have the measures set up between the ALL or ISFILTERED functions, but I'm at a loss. Any help on how to restructure would be greatly appreciated.
Here is the base measure for store performance:
% to Target Filtered = DIVIDE(SUM('Performance'[Actual]),sum('Quota'[Target]))
And here are the measures for District and Market level Performance
District % to Target Filtered = calculate(DIVIDE(SUM('Performance'[Actual]),sum('Quota'[Target])),all(Hierarchy[Store])
Market % to Target Filtered = calculate(DIVIDE(SUM('Performance'[Actual]),sum('Quota'[Target])),all(Hierarchy[Store],Hierarchy[District]))
