How to write dax possitive values and nagative values sepeterately count.

[Anonymous]

Hi ,

Please help on below issues.

how to show positive valies count and nagative values count separately

positive :60

Nagitive values :40

Amount

10

20

30

-40

[Uzi2019]

hi @Anonymous 

please find below measures to calculate sum of positive and negative value

Positive =SUMX(table_name,IF(table_name[column ]>0,table_name[coulmn]))

Negative = SUMX(table_name,IF(table_name[column ]<0,table_name[coulmn]))

Please hit like and accept as a solution so other can get the answer.

[Anonymous · Accepted solution]

Hello @Anonymous 

Can you try with the below DAX measures

PositiveCount = 

CALCULATE(  COUNTROWS(NumbersCount),  FILTER(NumbersCount,NumbersCount[Values]>0))

NegativeCount=

CALCULATE(  COUNTROWS(NumbersCount),  FILTER(NumbersCount,NumbersCount[Values]<0))

Alternatively,

PositiveCount = COUNTAX( NumberTable, IF(NumberTable[Number]>0,NumberTable[Number]))

NegativeCount = COUNTAX( NumberTable, IF(NumberTable[Number]<0,NumberTable[Number]))

Hit Like if it's helped your query

Nandri