Forum Discussion
Calculate All : Include non shown filter
Brianoreilly Please try this as a "New Measure"
Test77 = CALCULATE(SUM(Test77Measure[BillableDays]),FILTER(ALL(Test77Measure),Test77Measure[ProjectID]=SELECTEDVALUE(Test77Measure[ProjectID])))
Test Data :
Output:
Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, the problem is likely your ALL filter so perhaps ALLEXCEPT([Resource Name) but really tough to tell what exactly is going on.
Thanks Greg_Deckler
The image posted is essentially the sample data.
I have one table.
Timecard Table
For example:
Resource Name | Project ID | Billable Days.
Alan 1 10
John 1 30
Amy 2 50
I want a calculated measure to show the sum of the total project billable days for all projects that the person has worked on.
Result:
Resource Name | Days Logged Billable All| Days Logged Billable All Project Dimension
Alan 10 40
John 30 40
Amy 50 50
For instance Alan worked on Project 1 for 10 days. John also worked on Project 1 for 30 days, so the Total Project Billable Days should be 40.
Hope this helps.