Forum Discussion
Solved
help with measure
I need to take a measure and place it in all the rows. to later perform a subtraction between two variables, I can calculate the measure but I cannot replicate it in all the rows or perform the calcu...
@hansaraneda You can add ALL() if you want it to be calculated on all data/rows.
previous balance amount 2 - DIVIDE(CALCULATE(SUM(Query1[saldo_anterior])),(CALCULATE(SUM(Query1[saldo_anterior]),Consultation1[Label]-"Entry of Ordinary Activities", ALL())),0)
the problem is that I do that but it only calculates it on the same ignoring the rest of the rows
monto saldo anterior 2 = DIVIDE(CALCULATE(SUM(Consulta1[saldo_anterior])),(CALCULATE(SUM(Consulta1[saldo_anterior]),Consulta1[Etiqueta]= "Ingreso de actividades ordinarias")),0)