Power BI - Measure : How to get a sum measure to change based on slicer

[Materous]

I have a measure that is taking the sum of a column * another measure. 

SUM(Column1) * Measure1

However when I select a subset, for example a month row in the data table, the total measure value doesn't change to match the value for just that month in another table visual. It keeps the overall value, is there any way to get the measure value to change based on table row selection?

Example tables :
Table one

Month	Value Of Measure : SUM(Column1) * Measure1	Measure 2 : SUM(Column1) * Measure1 / Quantity
1/1/2022	10	2
2/1/2022	10	2
3/1/2022	10	2
Total	30	2

Table two

Segment	Value Of Measure : SUM(Column1) * Measure1	Measure 2 : SUM(Column1) * Measure1 / Quantity
1	5	2
2	15	2
3	10	2
Total	30	2

Is there a way if I select a row in table 1 that table 2 shows the value of the measure as the total? For example if I select row 1 in table 1 the total show for column 2 in table 2 should now be 10 instead of 30.

[v-zhangti]

Hi, @Materous 

I have not been able to fully understand, please advise the relationship between Tables 1 and 2. Can you provide more sample data for testing?

Best Regards,

Community Support Team _Charlotte

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