Incorrect row total

Question

Nice day
Someone can advise me, I have problems calculating the total number of rows, at other times use measures such as
Hasonevalue, isinscope, filter, among others for the column total, however
how can I correct the total, but in columns?

since when applying a measure it is calculated row by row applying the given filters and in the total, instead of adding the result of each column subtotal, it performs the same operation of the measure with these same filters obtaining an incorrect column total. Thank you!

I share my example:

I have the following:

Falls=

Var soff = SELECTEDVALUE(WeeksOneContact[WEEK OC])

Var Hvta =

CALCULATE(

DISTINCTCOUNT('Hijos Venta'[id_empleado_hijo]),

'Hijos Venta'[Hijos Vta] = "Vendio",,

FILTER( ALL(WeeksOneContact[WEEK OC]),

WeeksOneContact[WEEK OC] = soff))

Var hard = SELECTEDVALUE(WeeksOneContact[Week OC])-1

Var HNovta =

CALCULATE(

DISTINCTCOUNT('Hijos Venta'[id_empleado_hijo]),

'Hijos Venta'[Hijos Vta] = "Vendio",,

FILTER( ALL(WeeksOneContact[WEEK OC]),

WeeksOneContact[Week OC] = hard))

Var Caen =
IF(HNovta=0,Hvta,0)

Return

sumX(ALLSELECTED('Children Sale'[id_empleado_hijo]),[Caen])

v-easonf-msft · Accepted Answer

Hi,&nbsp;Syndicate_Admin&nbsp;
Please add a new measure to replace 'falls':
New falls =
IF (
    ISINSCOPE ( 'WeeksOneContact'[Week OC] ),
    [Falls],
    SUMX ( ALLSELECTED ( 'WeeksOneContact'[Week OC] ), [Falls] )
)

Best Regards,Community Support Team _ Eason
&nbsp;

Forum Discussion

Incorrect row total

2 Replies

Related content

Incorrect turnover total

Incorrect matrix row total

Measure Total Incorrect

Matrix Totals Incorrect

Incorrect total