Forum Discussion

jracer007's avatar
jracer007
Helper IV
8 years ago
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 positive and negative votes for each article?

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I would imagine something like:

     

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

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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    I would imagine something like:

     

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

NegativeCount = CALCULATE(SUM(Table[Column]),Table[Column] = -1) * -1
    • jracer007's avatar
      jracer007
      Helper IV
      8 years ago

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

      Thanks.