Measure to create a sum of one column based on matching values from another table

[Anonymous]

I have a column for Channel and its viewer in different regions in Table 1. This is weekly data.

In Table 2, I have Channel and your preferred region (one per channel).

I want to create a measure to display a chart that has channels and the sum of the audience for the preferred region.

I can't find a solution. I need help.

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may create relationship between the two tables above with "Both" of Cross filter direction, then create measure like DAX below.

Sum Viewer= SUM(Table1[Viewer])

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

If you join, slicer should help

Else refer

https://docs.microsoft.com/en-us/dax/treatas-function

OR Can you share sample data and sample output.