Forum Discussion
Solved
Negative and Positive
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 posit...
I would imagine something like:
PositiveCount = CALCULATE(SUM(Table[Column]),Table[Column] = 1) NegativeCount = CALCULATE(SUM(Table[Column]),Table[Column] = -1) * -1
I would imagine something like:
PositiveCount = CALCULATE(SUM(Table[Column]),Table[Column] = 1) NegativeCount = CALCULATE(SUM(Table[Column]),Table[Column] = -1) * -1
It worked, but I have some articles that do not have votes and when I put your formula they disappeared.
Thanks.
