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