Reply
Highlighted
Frequent Visitor
Posts: 7
Registered: ‎03-29-2018
Accepted Solution

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!

 

 


Accepted Solutions
Community Support Team
Posts: 2,711
Registered: ‎07-09-2016

Re: Syntax for Sum column removing filters on one column

@purpletiger,

 

You may try the measure below.

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

View solution in original post


All Replies
Community Support Team
Posts: 2,711
Registered: ‎07-09-2016

Re: Syntax for Sum column removing filters on one column

@purpletiger,

 

You may try the measure below.

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