Forum Discussion
Calculation by attribute not included in visual
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]
)
1 Reply
- amitchandak
Super User
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]) )orSumx(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]) )
