cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Filter SUM Measure with Date Splicer

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]))
Image 031.png
4 REPLIES 4
Super User IV
Super User IV

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...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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!

Resident Rockstar
Resident Rockstar

Hi @zsechler ,

 

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

Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

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

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors