Help Creating a Measure from one table by Partner to Match another Table

[jimbobobwalker]

I have two transaction tables, at first I created summary tables off both and created my calculations I needed from that, this visual is correct, its filtered by Partner field and comes from my RER_SUMMARY table, the field highlighted is from my OB_SUMMARY table, I was able to use that field in my RER_SUMMARY table to do all my Rate calculations by using the RELATED function:

So in order to have more robust visual I read that I should create measures instead so I went thru and created all the measures that I had created in my RER_SUMMARY table from the original RER_ACH_RETURNS table the problem is all my rate calculations are off becuase my base filed used in all of them is summing up all the Accepted Debit Entry Counts in the OB_ACH_ORIGINATED table and I need it to sum an match by the PARTNER in the two tables I tried this calculation that is highlighted in yellow, the highlighted in green are my numerators and the one in red is my denominator:

In the visual I tried bringing in the Partner field from both the OB_ACH_ORIGINATED table and the RER_SUMMARY table and filtering by Partner but that didn't work, the whole column is the total of all partners in the OB_ACH_ORIGINATED and not just the one I filtered by:

Any help would really be appreciated. thank you

[v-xuxinyi-msft · Accepted solution]

Hi @jimbobobwalker 

Based on the information you provided, the following is the case description: The measure value is not affected by Filters on this page.

But since I don't have your data I can't reproduce your formula. Could you please provide me with some sample data and the desired results based on these sample data? That would be very helpful. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Yulia Xu