Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    create a measure

    NewColumn = IF(CALCULATE(COUNTROWS(Software), Software[SoftwareSuite]="Adobe Reader") > 0, "custom value", "another value")
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

create a measure

NewColumn = IF(CALCULATE(COUNTROWS(Software), Software[SoftwareSuite]="Adobe Reader") > 0, "custom value", "another value")
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

     

    thanks again