cancel
Showing results for
Did you mean:
Member

## 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Negative and Positive

I would imagine something like:

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

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

Check-out my Back to School contest submission: Dinosaurs!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

2 REPLIES 2
Super User

## Re: Negative and Positive

I would imagine something like:

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

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

Check-out my Back to School contest submission: Dinosaurs!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Member

## Re: Negative and Positive

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

Thanks.

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 302 members 3,401 guests
Recent signins: