Measure Help Across Tables With Bridge

Hi matthew_hampton

Create relationships between Table A and Table B by Bridge Table

Calculate sum of USOC Charges where AccountID = AccountID and EOM Load Date = EOM Load Date

Measure =
CALCULATE (
    SUM ( Sheet2[ USOC_Charge ] ),
    FILTER (
        ALL ( Sheet2 ),
        [AccountID] = SELECTEDVALUE ( Sheet2[AccountID] )
            && [EOM Load Date] = SELECTEDVALUE ( Sheet2[EOM Load Date] )
    )
)

How do you want to use Period (in Table A) in visualization?

How does Period (in Table A) affect sum of USOC Charges? Could you make me clear about these?

Best Regards

Maggie