Forum Discussion
Help with a calculated column
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 |
Hi Anonymous
create a measure
NewColumn = IF(CALCULATE(COUNTROWS(Software), Software[SoftwareSuite]="Adobe Reader") > 0, "custom value", "another value")
2 Replies
Hi Anonymous
create a measure
NewColumn = IF(CALCULATE(COUNTROWS(Software), Software[SoftwareSuite]="Adobe Reader") > 0, "custom value", "another value")