Calculation by attribute not included in visual

[LupinAinsworth]

Hello. I have written the following measure to return certain measures if they are populated/blank. I need to update this measure to calculate specifically on a department level for each condition. Can anyone help? I feel like this is some sort of summarize/groupby type functionality. And this will need to be done in a measure as unfortunately calculated columns are not an option for me. And using department in the visual is not an option, either.

Thank you!

SWITCH (

TRUE,

NOT ( ISBLANK ( [Units of Service Actual] ) ) && NOT ( ISBLANK ( [Worked Benchmark Hours] ) ), [Worked Benchmark Hours],

NOT ( ISBLANK ( [Units of Service Actual] ) ) && ISBLANK ( [Worked Benchmark Hours] )

&& NOT ( ISBLANK ( [Units of Service Budget] ) ), [Flexible Budget Hours],

ISBLANK ( [Units of Service Actual] ), [Fixed Budget Hours]

)

[amitchandak]

@LupinAinsworth , As these all are measure you need use a group by with values or more than that with summarize. You can try visual calculations also

Sumx(Values(Dim[Dim COlumn]) ,

SWITCH (

TRUE,

NOT ( ISBLANK ( [Units of Service Actual] ) ) && NOT ( ISBLANK ( [Worked Benchmark Hours] ) ), [Worked Benchmark Hours],

NOT ( ISBLANK ( [Units of Service Actual] ) ) && ISBLANK ( [Worked Benchmark Hours] )

&& NOT ( ISBLANK ( [Units of Service Budget] ) ), [Flexible Budget Hours],

ISBLANK ( [Units of Service Actual] ), [Fixed Budget Hours]

) )

or

Sumx(Summarize(Fact, Dim[Dim COlumn], Dim[Dim COl2]) ,

SWITCH (

TRUE,

NOT ( ISBLANK ( [Units of Service Actual] ) ) && NOT ( ISBLANK ( [Worked Benchmark Hours] ) ), [Worked Benchmark Hours],

NOT ( ISBLANK ( [Units of Service Actual] ) ) && ISBLANK ( [Worked Benchmark Hours] )

&& NOT ( ISBLANK ( [Units of Service Budget] ) ), [Flexible Budget Hours],

ISBLANK ( [Units of Service Actual] ), [Fixed Budget Hours]

) )