Available hours calculation depending on nr of resources

[Nicolette]

I have a column that calculates workdays between two dates.

Then I have a table with the list of all resources, but only certain resources are selected for the card I am displaying.

I need to do the following:  AvailableHours = Workdays * 8 * the number of selected resources.

What would be the correct way get this?

[Anonymous]

Hi @Nicolette ,

Try SELECTEDVALUE function or ALLSELECTED function.

It's better to provide dummy sample data and expected results if you're still confused about it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nicolette]

Hi Stephan, thanks for the answer.

When I user the following, I expect to get 10 days.

WorkDays = CALCULATE(COUNTROWS('Calendar'),DATESBETWEEN ( 'Calendar'[Date], min('Combined Task'[Iteration Start Date]), max('Combined Task'[Iteration End Date])),'Calendar'[IsWorkDay] = TRUE(), ALLSELECTED('Combined Task'))

When I created this as a column in the 'Combined Task' table, it gave the correct answer, but then I could not pick it up to use in a different measure.

When I create this in the 'Resource' table where I have a list of resources, roles and availability, it gives me an answer of 1

Could you point to an article of when to user Column, Measure and how to determine in which table it should be?

Thank you

[Anonymous · Accepted solution]

Hi @Nicolette ,

Typically, a measure is a dynamic result, while a calculated column is a static result.

This blog post is written for you if you want to understand the difference between Calculated Column and Measure in DAX, and have any of below questions;

What is Calculated Column?
What is Measure?
When should I write calculated column or measure?
What is their difference in Performance?
What are operations that I cannot do with these?
and many other questions about the difference between these two types of calculations in DAX.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.