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 )
)
Arul's avatar
Arul
Icon for Super User rankSuper User
4 years ago

Nick_2510 ,

try this,

Negative val = SUMX(Negative,IF(Negative[Diff]<0,1,0))

 

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

This formula is not for measures