<div>
What would happen if you changed TotalMailingCount to a measure? &nbsp;Then did the divide? &nbsp;Also what is the relationship between SegmentAnalysis2.1? &nbsp;One to many? &nbsp;Which side is the one?
</div>


<div>
I can't seem to make TotalMailingCount a measure as it doesn't seem to recognize it yet I can add it to a visualization. &nbsp;It's based on a different table than the other fields. &nbsp;<br><br>The GiftsPerSegment table is based on results from the mailing in our database, the TotalMailingCount is from the mail house stats on the number of pieces mailed. &nbsp;They are only related by the SegmentAnalysis2.1 field.<br><br>On the tables the 1 side is on the InitialMailingCounts table.<br><br>I'm relatively new to Power BI maybe I have something fundamentally wrong?<br><br><br><br>
</div>


<div>
Related will not work with tables which have Many to Many relationship between them. Related normally works on table with Many side fetching the related values from the dimension table.
</div>


<div>
I was able to fix the join to be 1 to many. Unfortunately, it still doesn't recognize the InitialMailinCounts fields when I try to create the column. &nbsp;<a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562240/PowerBI2.JPG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562240/PowerBI2.JPG" class="fr-fic fr-dib"></a>
</div>


Image-2.JPG

PowerBI2.JPG

<div>
What error you get after fixing the relationship?<br>Are you sure that you are creating a calculated column on Many side?<br>Can you upload the pbix file?
</div>


<div>
After a little more testing I was able to add a measure and use it in the calculation but I still have a couple of issues.&nbsp;<br><br>When I add the TotalMailCount to the table visualization it doesn't display a grand total on the bottom of the column. &nbsp;Also the response rate is a sum of the values above when it should really be TotalNumberofDonors/TotalMailingCount.<br><br>Is there a way of changing the total row for individual columns?<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562244/PowerBI3.JPG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562244/PowerBI3.JPG" class="fr-fic fr-dib"></a><br><br>
</div>


PowerBI3.JPG

<div>
What is the formula for the Response Rate? &nbsp;And how did you determine your TotalMailingCount?<br><br><br>
</div>


<div>
ResponseRate = [NumberOfDonors]/RELATED(InitialMailingCounts[TotalMailingCount])<br><br><br>
</div>


<div>
Total mail count was just a table with the number of pieces mailed.
</div>


<div>
Your Response Rate calculation % does not look right. &nbsp;The percentages are slightly off.
</div>


<div>
The problem of making the % a calculated column is why you have the percentage total at the bottom of your visual. &nbsp;The % calculation should be a measure. It would be beneficial if you uploaded the file as Subodh suggested.<br><br><br>
</div>


<div>
Sure, sorry I missed uploading it. I was able to get the TotalMailCount grand total to display but haven't made any progress on the ResponseRate detail or grandtotal.<br><br><br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562247/CASAMailFileAnalysis.pbix" rel="ugc">CASAMailFileAnalysis.pbix</a>
</div>


CASAMailFileAnalysis.pbix

CASAMailFileAnalysis2.pbix

Executive Director of IT

Andy Donnelly

<div>
Thanks for the points. &nbsp;Glad to help...
</div>


<div>
<div class="content wysiwyg-content fr-view">
I'm having difficulty creating a calculated column. &nbsp;I've attached the table layout for the three tables in the visualization. &nbsp; I tried the following calculated column statement:<br>ResponseRate = (GiftsPerSegment[NumberOfDonors])/RELATED(InitialMailingCounts[TotalMailingCount])<br>&nbsp;and I get an error:<br>"The column 'Initial Mailing Counts[TotalMailingCount] either doesn't exist or doesn't have a relationship to any table available in the current context. &nbsp;I'm not sure why since the two tables are joined. &nbsp;Any help would be greatly appreciated.<img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562190/PowerBITables.JPG" class="fr-fic fr-dib">"&nbsp;&nbsp;
</div>
</div>


PowerBITables.JPG


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.
"  

Creating a calculated column from two tables in Power BI

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.