Cannot figure out what formula is appropriate - lookup and sum

[PowerNewbie98]

Hi all, 

I am new to this system and I'm on struggle street trying to figure it out. What I am trying to do is, get powerBI to look up the value (Maybe filter by the value?I'm not sure) 'revenue' from say 'column 1' and find all instances of that word, and then sum the figures in 'column 2' that correspond with it. Any formula suggestions welcome. 

Thank you!

[Idrissshatila · Accepted solution]

Hello @PowerNewbie98 ,

try this

Measure = calculate( sum(YourTableName[column2]),YourTableName[column1] = "Revenue")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[PowerNewbie98]

Thanks for that!

Would you also happen to know how I could exclude revenue and sum every other category in column 1? my overall aim is to caclculate the gross profit. for eg my data looks sort of like this:

Acct Type	$
Revenue	100
Staples	10
Markers	20
paper	30

[Idrissshatila · Accepted solution]

HEllo @PowerNewbie98 ,

try the following 

Measure = calculate( sum(YourTableName[column2]),YourTableName[column1] <> "Revenue")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Idrissshatila · Accepted solution]

Hello @PowerNewbie98 ,

try this

Measure = calculate( sum(YourTableName[column2]),YourTableName[column1] = "Revenue")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡