Creating Production Model

[Anonymous]

In my data model, there are 
1. Monthly Planned Ratio table

2. Monthly Actual Production table

3. Calendar table

To know exact conumpstion based on planned ratios, i am using the formula

IO Ratio_CP_CSL =

CALCULATE(

    MAXX(

        Ratio_CSL,

        Ratio_CSL[QTYperDMT]

    ),

    USERELATIONSHIP(

        Ratio_CSL[Month],

        'A. Calendar'[Dates]

    )

)

Now it is working fine as long as any one month is selected in slicer but as soon as multiple months are filtered, it is selecting the maximum value of Ratio from selected month and multiplying it by each month's production.

What i want is to get
Jan= Ratio * Production

Feb = Ratio * Production

Multiple Months selected = 
sum (Jan= Ratio * Production + Feb= Ratio * Production)

Hope this makes sense. Looking forward to get some guidance on this.

[bhelou]

Dear , Kindly share an example if possibile , 

see if this measure works with you : 

Kindly accept as a solution if it works with you and a kudo will be great . 

Regards , 

IO Ratio_CP_CSL =
SUMX (
    VALUES ( 'A. Calendar'[Month] ),
    VAR SelectedMonth = 'A. Calendar'[Month]
    RETURN
        CALCULATE (
            MAXX ( Ratio_CSL, Ratio_CSL[QTYperDMT] ),
            USERELATIONSHIP ( Ratio_CSL[Month], 'A. Calendar'[Dates] ),
            'A. Calendar'[Month] = SelectedMonth
        ) * [Actual Production]
)