Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am currently developing an app where I need to duplicate a same measure with different conditions each time. My problem/error comes when trying to use a comparison filter different from equal for a numeric field:
SUM({<[AÑO RF]={$(vL.AñoActual)},[MES RF]={$(vL.MesActual)}, [LINEA RF]={3330,3350}>}[PESO RF])
That works fine but:
SUM({<[AÑO RF]={$(vL.AñoActual)},[MES RF]={$(vL.MesActual)}, [LINEA RF]={3330,3350}, ACX<={3544}>}[PESO RF])
gives the following error:
Error in set modifier expression
Can anyone help me? Please? 😖
Short version - you don't use <= in this context, you place that within the search (inside the curly brackets).
Maybe like this
Sum({<[AÑO RF]={$(vL.AñoActual)},[MES RF]={$(vL.MesActual)}, [LINEA RF]={3330,3350}, ACX={"<=3544"}>}[PESO RF])
Short version - you don't use <= in this context, you place that within the search (inside the curly brackets).
Maybe like this
Sum({<[AÑO RF]={$(vL.AñoActual)},[MES RF]={$(vL.MesActual)}, [LINEA RF]={3330,3350}, ACX={"<=3544"}>}[PESO RF])