Why doesn´t makes subtotals

[Luis_Caston]

Dear all,

Take a look at this:

The point 2 is filtered by Point 1:

• Coste Directo entradas
• Coste Directo Salidas

At the Point 2 if I see any one of them individually as you can check at "II" and "III" levels I see results.

But if you pay attention at level "I" that is shrink there is no values.

Do you know why? Is due to the measure?

The measure that applies are:

Neto Analitica Unitario:

IF(OR(SELECTEDVALUE(Analitica[Nivel1]) = "COSTE INDIRECTO CAMPO",

SELECTEDVALUE(Analitica[Nivel1]) = "COSTE INDIRECTO SALIDAS"), CALCULATE([Neto Analitica Unitario Prev.]),

SUMX(values(Articulo[FamiliaSuperior]), [Neto Analitica Unitario Prev.]))

That comes from here:

Neto Analitica Unitario Prev. =

VAR _Calculo = SWITCH (

    SELECTEDVALUE ( Analitica[Nivel1] ),

    "VENTAS", DIVIDE([Total Venta Analitico], [Peso Neto Salidas]),

    "COSTE DIRECTO ENTRADAS", [Coste Unitario Directo Entradas Año Natural],

    "COSTE DIRECTO SALIDAS", DIVIDE( [Coste Directo Salida], [Peso Neto Salidas]),

    "MARGEN BRUTO",

        ROUND(DIVIDE([Total Venta Analitico], [Peso Neto Salidas]),2)

            - ROUND([Coste Unitario Directo Entradas Año Natural],2)

                - ROUND(DIVIDE( [Coste Directo Salida], [Peso Neto Salidas]),2),

    "COSTE INDIRECTO SALIDAS", DIVIDE([Coste Indirecto Salidas] * ( -1 ), [Peso Neto Salidas]),

    "COSTE INDIRECTO CAMPO", DIVIDE([Coste Indirecto Campo], [Peso Neto Salidas Proveedor Interno]) * (-1),

    "COSTE DIRECTO CAMPO",[Coste Unitario Directo Campo Prev.],

    "MARGEN NETO",

       ROUND(CALCULATE(ROUND(DIVIDE( [Total Venta Analitico], [Peso Neto Salidas]),2)

        - ROUND([Coste Unitario Directo Entradas Año Natural],2)

            - ROUND(DIVIDE( [Coste Directo Salida], [Peso Neto Salidas]),2)

                 - ROUND(DIVIDE([Coste Indirecto Salidas] * ( -1 ), [Peso Neto Salidas]),2)

                    + ROUND(DIVIDE([Coste Indirecto Campo], [Peso Neto Salidas Proveedor Interno]),2)

                        -  ROUND([Coste Unitario Directo Campo Prev.],2)),2))

RETURN

IF([Peso Neto Salidas] <> BLANK(), _Calculo, BLANK())

Any idea?

[MFelix]

Hi @Luis_Caston ,

This calculation is not getting the subtotal since you are using the SELECTEDVALUE(Analitica[Nivel1]) = "COSTE INDIRECTO CAMPO" this is forcing you calculation to check the value for Nivel1 so other levels will not get any values since they are not level 1.

Depending on how you have setup the other levels in this case what is identified in your table visual as I and II you need to have a SUMX of the Neto Analitica Unitario based on I and II columns

[Luis_Caston]

Hi @MFelix!

So I've to make a SUMX according to I and II levels?

[MFelix]

Hi @Luis_Caston ,

Yes the calculation must have a SUMX at level I and II

[Luis_Caston]

Hi @MFelix !
In this case I'm filtering the object with those both:

"COSTE DIRECTO ENTRADAS", [Coste Unitario Directo Entradas Año Natural],

    "COSTE DIRECTO SALIDAS", DIVIDE( [Coste Directo Salida], [Peso Neto Salidas]),

How de I must change Neto Analitico Unitario?

[MFelix]

Hi @Luis_Caston ,

For I and II how is the calculation to be done a sum of the previous ones, and average? how does it calculate?