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?
Go to Solution.
I would imagine something like:
PositiveCount = CALCULATE(SUM(Table[Column]),Table[Column] = 1)
NegativeCount = CALCULATE(SUM(Table[Column]),Table[Column] = -1) * -1
Proud to be a Datanaut!
It worked, but I have some articles that do not have votes and when I put your formula they disappeared.Thanks.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.