Forum Discussion

Nick_2510's avatar
Nick_2510
Icon for Helper I rankHelper I
4 years ago
Solved

count all negative numbers

I want to count all negative numbers by rows and in total...but it doesn't work in total M = SUMX ( VALUES ( Data[Name] ), IF ( [diff_AvSal_bal] < -1, 1, 0))    
  • tamerj1's avatar
    tamerj1
    4 years ago

    Nick_2510 
    Please try

    Count of -ve =
SUMX (
    CROSSJOIN ( VALUES ( 'Date'[Date] ), VALUES ( Data[Name] ) ),
    IF ( [diff_AvSal_bal] < -1, 1, 0 )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Nick_2510 

Maybe you mean "AND" not "OR". Please try replace || with &&

Nick_2510's avatar
Nick_2510
Icon for Helper I rankHelper I
4 years ago

tamerj1 
No, I mean put 0 if name on this day is in delist OR diff_AvSal_bal > 0...but it takes 1...I tried to reverse conditions and got error

 

OOS =
SUMX (
CROSSJOIN ( VALUES ('Календарь'[Date]), VALUES ( Glossary[Name] ) ),
IF ('Календарь'[Date] IN
CALENDAR (
CALCULATE ( SELECTEDVALUE ( delist[Start_per] ) ),
CALCULATE ( SELECTEDVALUE ( delist[End_per] ) )
||
[diff_AvSal_bal] > 0
),
0, 1 )
)
 
Calendar start date or end date cannot be null