Forum Discussion

purpletiger's avatar
purpletiger
Frequent Visitor
8 years ago
Solved

Syntax for Sum column removing filters on one column

Hello! It seems as if my syntax is incorrect:

 

Measure = calculate(sum(Table[Hrs]),filter(ALL(Table[Billable]), Table[Category]="Time Off"))

 

I am trying to calculate the days off (Vacation, holidays and sick) for use in an utilization calculation. I want the measure to recognize the time based filters but not filters if it is billable time as there is other non-billable time such as internal meetings. 

 

Thank you for your help!

 

 

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    purpletiger,

     

    You may try the measure below.

    Measure =
CALCULATE (
    SUM ( Table1[Hrs] ),
    ALL ( Table1[Billable] ),
    Table1[Category] = "Time Off"
)

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    purpletiger,

     

    You may try the measure below.

    Measure =
CALCULATE (
    SUM ( Table1[Hrs] ),
    ALL ( Table1[Billable] ),
    Table1[Category] = "Time Off"
)