cancel
Showing results for
Did you mean:
jracer007 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

I have book! Learn Power BI from Packt

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

I have book! Learn Power BI from Packt

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

Proud to be a Datanaut!

Highlighted
jracer007 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 Top Kudoed Authors
Users Online
Currently online: 290 members 3,018 guests
Recent signins:
• norway84 • hv11709 • rranieri • WinniLuo • bpaynetrain1 • GavinClark • rajanimaddala • cjmiszuk • gheisargheisar • tesch70 • gabby03 • virenjk • Domenick • bfoster 