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 )
)
Nick_2510's avatar
Nick_2510
Icon for Helper I rankHelper I
4 years ago

Hi! The same result(

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Nick_2510 
Do you have other active filters of the page or on the visual? any slicers? Any other table or other column invloved?