Calculate the amount of available hours

[Anonymous]

Hi!

I have a table with 5 columns:

I'm having some trouble to calculate the measure Total_Hours. I put this information on a column just to show the results.

Basically this measure is the amount of Available Hours:

Total_Hours = CALCULATE(MAX('Table'[Available]),ALLEXCEPT('Table','Table'[Colab],'Table'[Month]))* CALCULATE(DISTINCTCOUNT('Table'[Colab]),ALLEXCEPT('Table','Table'[Month]))

The problem is that this measure doesn't give the total. When placed on a visual card, it displays only 528 or 480 regardless of the filters.

What I need is a dinamic measure. So if the page doesn't have any selected filter, the result must to be 1.008. If the page has a filter the result needs to make sense with this filter. EXMPLES:

1- Any filter: The amount of Available Hours (Total_Hours) is 1008

2 - Filter in Colab (A): The amount of Available Hours (Total_Hours) is 336

3- Filter in Month (Jan): The amount of Available Hours (Total_Hours) is 528

4 - Filter in Colab (A) and Month (Jan): The amount of Availabe Hours (Total_Hours) is 176

Can anyone pls suggest me how to solve this?

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

sumx(summarize('Table', 'Table'[Colab],'Table'[Month],'Table'[Available]),[Available])

add filter like , if needed

sumx(summarize(filter('Table' ,'Table'[Colab] = "A"), 'Table'[Colab],'Table'[Month],'Table'[Available]),[Available])

[Anonymous]

Perfect! Thanks very much for your help!