Help with a calculated column

[Anonymous]

I am new to PowerBI so please forgive my newbie question here. I have two tables Computers and Software with a one to many relationship. I am trying to figure out how to determine if a ComputerID in the Computers table has Adobe Reader listed in the Software table and if so return a custom value and if not return another value.

Computers

ComputerID	DeviceName	NewColumn
1	Laptop1
2	Laptop2
3	Laptop3

Software

ComputerID	SoftwareSuite
1	Adobe Reader
1	Google Chrome
2	Google Chrome
2	AutoCAD
3	Adobe Reader

[az38 · Accepted solution]

Hi @Anonymous 

create a measure

NewColumn = IF(CALCULATE(COUNTROWS(Software), Software[SoftwareSuite]="Adobe Reader") > 0, "custom value", "another value")

[Anonymous]

Thanks, creating a measure did not seem to work, but using that formula in create a new column did work well.

thanks again