ALL() filtered by slicers coming from different tables in AS

[MCMM]

Hi all,

We are trying to create a calculation item called %sales that retrieves the difference between the first column and SALES OF PARTS for each row:

It is working by now, but we need to apply some slicer filters to this measure. The problem is that those filters are columns from other tables (star schema datamodel). The whole model has been developed in Analysis Services but this would be a simplification of the relationships:

The calculation group in columns has two items:

• Last full year = SELECTEDMEASURE()
• % SALES = DIVIDE ([P&L Mensual Actual],CALCULATE([SALES OF PARTS], ALL()))*100

[P&L Mensual Actual] is the measure we use in the matrix to replace the SELECTEDMEASURE() and [SALES OF PARTS] is the equivalent of the first row in the matrix.

Right now, the filters are applying only to the [Last full year] because of the ALL() Dax:

How can we apply the slicers to %Sales if they come from different tables?

Thanks in advance.

[amitchandak · Accepted solution]

@MCMM , You can try

% SALES = DIVIDE ([P&L Mensual Actual],CALCULATE([SALES OF PARTS], ALLselected()))*100

or

% SALES = DIVIDE ([P&L Mensual Actual],CALCULATE([SALES OF PARTS], ALL(Table[P&L structure])))*100