Weighted Average

Merge table in PQ

Or DAX measures,

Ratio = 
IF (
    ISINSCOPE ( 'CASES'[Country] ),
    CALCULATE (
        AVERAGE ( LOOKUP[Value] ),
        TREATAS (
            SUMMARIZE ( 'CASES', 'CASES'[Date], LOOKUP[Country] ),
            LOOKUP[Date],
            LOOKUP[Country]
        )
    )
)

Total Weighted = 
SUMX (
    DISTINCT ( 'CASES'[Country] ),
    CALCULATE ( MAX ( 'CASES'[Males] ) ) * [Ratio]
)

Hi WestWinter ,

Try like below ,create two column:

Column = 
VAR lookupvalue1 =
    LOOKUPVALUE (
        'Table B'[Value],
        'Table B'[Date], TableA[Date],
        'Table B'[Country], TableA[Country],
        0
    )
RETURN
    lookupvalue1 * TableA[Males]

Weighted Average = 
SUMX (
        FILTER ( TableA, TableA[Region] = EARLIER ( TableA[Region] ) ),
        TableA[Column]
    )
        / CALCULATE (
            COUNT ( 'TableA'[Country] ),
            FILTER ( TableA, TableA[Region] = EARLIER ( TableA[Region] ) )
        )

Final get :

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Best Regards

Lucien