Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I add my "Income from Services" as long as the type of service is different form "04. Tarjetas y bonos"?
Thanks a lot!!
Solved! Go to Solution.
@4pepesanchez4 My mistake
Total Ingr.Servicios Iva Incluido =
CALCULATE (
SUM ( Table[Ingr.Servicios Iva Incluido] ),
Table[Servicios_Productos.Tipo Servicio] <> "04. Tarjetas y bonos"
)
it´s giving me an error. Dont i have to put the SUM too?
Ventas Reales:=CALCULATE(SUM(Mensuales[Ingr. Servicios Iva Incluido]; Mensuales[Servicios_Productos.Tipo Servicio] <> "04. Tarjetas y Bonos"))
@4pepesanchez4
You may try
Total Ingr.Servicios Iva Incluido =
CALCULATE (
Table[Ingr.Servicios Iva Incluido],
Table[Servicios_Productos.Tipo Servicio] <> "04. Tarjetas y bonos"
)
@4pepesanchez4 My mistake
Total Ingr.Servicios Iva Incluido =
CALCULATE (
SUM ( Table[Ingr.Servicios Iva Incluido] ),
Table[Servicios_Productos.Tipo Servicio] <> "04. Tarjetas y bonos"
)
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
38 | |
21 |