Measure for calculating percentage from total hours

[RobertasUC]

Hello,

I have an issue with measure, which when added to visual (table or matrix) does not calculate properly. I need this measure to show percentage from total hours by driver1 name multiplied by fixed_cost. Instead, this measure for percentage calculation simply takes total row hours and divide from same total row hours (instead of dividing from total hours grouped by driver1 name).

RE ES Fixed Costs =

VAR SelectedMonths = VALUES('RE ES Query'[Month])

VAR SelectedYear = SELECTEDVALUE('RE ES Query'[Year])

VAR TotalHoursPerDriver =

    SUMX(SUMMARIZE('RE ES Query','RE ES Query'[Driver1 Name]),CALCULATE(SUM('RE ES Query'[Hours]))

    )

RETURN

    -CALCULATE(

        SUM('Contribution Rates'[fixed_cost]),

        'Contribution Rates',

        'Contribution Rates'[division] = "OTREAST",

        'Contribution Rates'[year] = SelectedYear,

        'Contribution Rates'[month] IN SelectedMonths

    ) * sum('RE ES Query'[Hours])/TotalHoursPerDriver

[RobertasUC]

Thanks, @amitchandak, but this is not what I'm looking for. Adding more details:

Let's say in my slicer, week 7 is selected which is from 02/11/2024 to 02/17/2024. So for fixed costs calculation, I need to take fixed costs value from Contribution Rates table for February. Now, since only week 7 is selected, I want to calculate based on the following logic:

1. Driver 1 in week 7 has 4 rows with hours 64+49+4+5 = 167.
2. I need to allocate fixed cost (which is in the table Contribution Rates and it is weekly) and the allocation would be for each row. For example, first row = 64 (first row hours) / 167 (total week hours) * 1499 (OTREAST fixed cost).

Contribution Rates table snip:

RE ES Query table snip:

[amitchandak]

@RobertasUC , You can create a calculated column in RE ES Query,if Month and year is a key, or add more columns as per need

new column

Total = 'RE ES Query'[Hours] * Maxx(FIlter('Contribution Rates',   'Contribution Rates'[Month] = 'RE ES Query'[Month] &&  'Contribution Rates'[year]  = 'RE ES Query'[Year] ), 'Contribution Rates'[fixed_cost])

or with division

Total = 'RE ES Query'[Hours] * Maxx(FIlter('Contribution Rates', 'Contribution Rates'[Month] = 'RE ES Query'[Month] && 'Contribution Rates'[year] = 'RE ES Query'[Year] && 'Contribution Rates'[Division] = 'RE ES Query'[Division] ), 'Contribution Rates'[fixed_cost])