Filter SUM Measure with Date Splicer

[zsechler]

Howdy All, I feel like this is easy but its not working so i need some help, please! When i adjust my splicer "Billable Hours" moves but Available does not.

• I am adding all the available working hours for every month
  • Measure is 'Available Hours' below
• I need the outcome of available hours to be filtered down by the splicer date.
  • i am using 'Billed Hours'[Date] in my splicer

Available Hours = CALCULATE(SUM('1_January Available Hours'[Value])+SUM('2_February Available Hours'[Value])+SUM('3_March Available Hours'[Value])+SUM('4_April Available Hours'[Value])+SUM('5_May Available Hours'[Value])+SUM('6_June Available Hours'[Value])+SUM('7_July Available Hours'[Value])+SUM('8_August Available Hours'[Value])+SUM('9_September Available Hours'[Value])+SUM('10_October Available Hours'[Value])+SUM('11_November Available Hours'[Value])+SUM('12_December Available Hours'[Value]))

[amitchandak]

Please share more details about your measures.To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[zsechler]

Hi @amitchandak i sent you a PM of my PBIX file so its not being shared with the masses. Let me know if i can provide more insight! thank you for the help!

[danextian]

Hi @zsechler ,

Wouldn't it be easier if you combined all your available hours tables into one instead importing them into your model separately? 

[zsechler]

Yes it would. haha Unfortunately i am using OpenAir and the "daily" filters only allows up to 90 days....(insert crying)