Dividing Measure by another measure according to values inside matching

[dexter00000]

Hello,

I have 2 tables which are related and has the same CH_NAME and i am trying to get TobeDivided Measure to be divided by the other one but it should be CH_NAME by CH_NAME like

 ABC should divide ABC and DAB should divide DAB

These are my measures how do i get tobedivided's values to be divided by the other measure

TobeDivided =
CALCULATE (
SUM ( 'Table2022'[MONEY] ),
ALLSELECTED ( 'Table2022' ),
VALUES ( 'Table2022'[CH_NAME] )
,
FILTER('Table2022',VALUE('Table2022'[YEAR]) = 2022 && VALUE('Table2022'[MONTH]) = 8 && VALUE('Table2022'[DAY]) = 31 && VALUE('Table2022'[CODE]) = 120)
)


Divider =
CALCULATE(SUM('Income'[MONEY]),FILTER('Income','Income'[DÖNEM] = "HAZİRAN" && ('Income'[KEBİR] = "600" || 'Income'[KEBİR] = "602") ))
+
CALCULATE(SUM('Income'[MONEY]),FILTER('Income','Income'[DÖNEM] = "TEMMUZ" && ('Income'[KEBİR] = "600" || 'Income'[KEBİR] = "602") ))
+
CALCULATE(SUM('Income'[MONEY]),FILTER('Income','Income'[DÖNEM] = "AĞUSTOS" && ('Income'[KEBİR] = "600" || 'Income'[KEBİR] = "602") ))

I use ToBeDivided measure to use CH_NAME with in a graphic and Divider with CH_NAME in another graphic and i need a graphic with matching CH_NAME's being divided to each other
I am trying to achieve wsomething like this RETURN CALCULATE(DIVIDE(ToBeDivided,Divider),FILTER(GROUP BY CH NAME of some sorts i don't know at this point))

[v-easonf-msft]

Hi, @dexter00000 

Is there a relationship between 'Table2022' and 'Income'?

You may need to create a separate dimension table 'CH NAME Table' and create a one-to-many bidirectional relationship with the other two tables.
Calculated table:

CH NAME Table = DISTINCT(UNION(VALUES(Income[CH_Name]),VALUES('Table 2022'[CH_Name])))

Then you can use formula below with new field  'CH NAME Table'[CH_Name]  in a new table visual.

result=DIVIDE(ToBeDivided,Divider)

Best Regards,
Community Support Team _ Eason

[dexter00000]

thank you for your reply i couldn't get back to this yet if i need it and it works i'll make sure to accept as solution.