Forum Discussion

Brianoreilly's avatar
Brianoreilly
Helper II
7 years ago
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 "...
General Comment
Need Help
Tutorial Requests
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Brianoreilly Please try this as a "New Measure"

     

    Test77 = CALCULATE(SUM(Test77Measure[BillableDays]),FILTER(ALL(Test77Measure),Test77Measure[ProjectID]=SELECTEDVALUE(Test77Measure[ProjectID])))

    Test Data :

     

    Output:

Brianoreilly's avatar
Brianoreilly
Helper II
7 years ago

Thanks ssugar, 

 

However this will not work as I want to use a date slicer and I need to calculate this via a measure. 

 

 

Thanks for trying though. 

 

Regards

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Brianoreilly Please try this as a "New Measure"

 

Test77 = CALCULATE(SUM(Test77Measure[BillableDays]),FILTER(ALL(Test77Measure),Test77Measure[ProjectID]=SELECTEDVALUE(Test77Measure[ProjectID])))

Test Data :

 

Output: