Measure does not overcome filter to compute % of Sales

[danielboi]

Hello community,

I am having issues to make one measure work. This measure is to be used to show Profit and Loss items, where I define the filter context through visual filter. 

In order to not have a specific sets of measures per P&L items there is a set of generic measures, which visual filters are applied on. The filter is on dim.table[P&L item].

The measures calculating the actual, budget and difference between those two work fine. It also calculates the filtered values in % of sales AS LONG AS I do NOT make a drill down using dim.table[P&L item].  If I use any other attribute I get to see the sales despite the visual filtering out the sales.

But if want to drill down according to dim.table[P&L item] sales does not get to passed on.

The measure used is:

CALCULATE(

[Sales Bud],

ALL(Report_Item[P&L Item])

Data model consists out of one fact table and several dimension tables for calendar, PL items, locations, Org Hierarchy. All linked to the fact table.

Any hints how to make the formula work to pass down sales for computation?

Cheers

D

[danielboi · Accepted solution]

Managed to solve the mystery by myself.

The formula used:

CALCULATE(

[Sales Bud],

ALL(Report_Item[P&L Item])

Should not show a column, but only the complete table.

CALCULATE(

[Sales Bud],

ALL(Report_Item)