Forum Discussion
Luis_Caston
Helper III
Helper IIIWhy doesn´t makes subtotals
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...
MFelix
Super User
Super UserHi 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_CastonHelper III
Helper IIIHi MFelix!
So I've to make a SUMX according to I and II levels?
- MFelix