Negative and Positive

[jracer007]

Hello,

I have two tables, one has the name of articles and its date of creation. The other table has positive (1) and negative (-1) votes in a single column.
How can I visualize the number of positive and negative votes for each article?

[Greg_Deckler · Accepted solution]

I would imagine something like:

PositiveCount = CALCULATE(SUM(Table[Column]),Table[Column] = 1)

NegativeCount = CALCULATE(SUM(Table[Column]),Table[Column] = -1) * -1

[jracer007]

It worked, but I have some articles that do not have votes and when I put your formula they disappeared.

Thanks.