- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Measure for calculating percentage from total hours
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:
- Driver 1 in week 7 has 4 rows with hours 64+49+4+5 = 167.
- 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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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])

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-22-2024 03:30 AM | |||
07-19-2024 04:49 AM | |||
05-08-2024 01:23 AM | |||
08-27-2024 05:03 AM | |||
05-08-2024 12:49 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |