Forum Discussion
Solved
Calculate All : Include non shown filter
Hi Folks, I have a Timecard Table with Resource Names, Projects Names and Billable Days Worked. In the example below, I have a subset of two projects, that looks at the time worked from a "...
Brianoreilly Please try this as a "New Measure"
Test77 = CALCULATE(SUM(Test77Measure[BillableDays]),FILTER(ALL(Test77Measure),Test77Measure[ProjectID]=SELECTEDVALUE(Test77Measure[ProjectID])))
Test Data :
Output:
I basically want the sum off all the Billable Project Days that the Resource has worked on.
If a resource spent 50 days billable on a project and someone else spent 150 days.
The figure I want is 200
I'm fairly certain that you will need to have a separate table of Project ID's as a dimension table in order to pull this off. Let me see what I can come up with.
Hi PattemManohar & Greg_Deckler,
The solution using the "Selected Value" worked!
Thanks for the help guys :)
You are gentlemen.