Forum Discussion
How to write dax possitive values and nagative values sepeterately count.
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 |
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 queryNandri
2 Replies
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 queryNandrihi 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.
