Wrong total sum in a table power desktop

[vicga2611]

Hi community,

Help solve this issue,

I am using this dax to bring "shoppers" projection with another "days of work" calculation. But the total of the "projection" column is wrong. All columns are messuare.

Proyeccion =

SWITCH(

    TRUE(),

    SELECTEDVALUE('03 SucursalesCECO [Excel]'[NOMBRE Sucursal]) = "SHOPPERS",

 [Venta Total [₡]]] + DIVIDE([Venta Total [₡]]], [Cantidad de dias Transcurridos Condicional]) * [Dias Restantes Condicionales]),

            [Venta Total [₡]]] + DIVIDE([Venta Total [₡]]] ,[Cantidad de dias Trancurridos]) *  [Dias Restantes del Mes])

[bhanu_gautam · Accepted solution]

@vicga2611 Try using

dax
Proyeccion Total =
SUMX(
'03 SucursalesCECO [Excel]',
SWITCH(
TRUE(),
'03 SucursalesCECO [Excel]'[NOMBRE Sucursal] = "SHOPPERS",
[Venta Total [₡]] + DIVIDE([Venta Total [₡]], [Cantidad de dias Transcurridos Condicional]) * [Dias Restantes Condicionales],
[Venta Total [₡]] + DIVIDE([Venta Total [₡]], [Cantidad de dias Trancurridos]) * [Dias Restantes del Mes]
)
)