Avatar of Andy Donnelly
Andy Donnelly
Flag for United States of America

asked on 

Creating a calculated column from two tables in Power BI

I'm having difficulty creating a calculated column.  I've attached the table layout for the three tables in the visualization.   I tried the following calculated column statement:
ResponseRate = (GiftsPerSegment[NumberOfDonors])/RELATED(InitialMailingCounts[TotalMailingCount])
 and I get an error:
"The column 'Initial Mailing Counts[TotalMailingCount] either doesn't exist or doesn't have a relationship to any table available in the current context.  I'm not sure why since the two tables are joined.  Any help would be greatly appreciated."  
Power BI

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon