Forum Discussion
Total always 0
Hi all I am not super expert in this kind of stuff so I need your help. I have a sales amount per sales document in different days. My goal is to make the sum of the canceled order (Canc OR 5). Whe...
Hi Anonymous
Please tryCanc OR 5 = SUMX ( VALUES ( 'Sales'[Sales Document] ), CALCULATE ( VAR checkval = CALCULATE ( [Orders Received Sales Amount], REMOVEFILTERS ( 'Sales' ), VALUES ( 'Sales'[Sales Document] ) ) VAR neg_ord = CALCULATE ( [Orders Received Sales Amount], FILTER ( 'Sales', [Orders Received Sales Amount] < 0 ) ) VAR canc_ord = IF ( checkval = 0, neg_ord ) RETURN canc_ord ) )
tamerj1
Community Champion
Community ChampionHi Anonymous
Please try
Canc OR 5 =
SUMX (
VALUES ( 'Sales'[Sales Document] ),
CALCULATE (
VAR checkval =
CALCULATE (
[Orders Received Sales Amount],
REMOVEFILTERS ( 'Sales' ),
VALUES ( 'Sales'[Sales Document] )
)
VAR neg_ord =
CALCULATE (
[Orders Received Sales Amount],
FILTER ( 'Sales', [Orders Received Sales Amount] < 0 )
)
VAR canc_ord =
IF ( checkval = 0, neg_ord )
RETURN
canc_ord
)
)Great, tamerj1, it works!! Thanks