Sum In One Measure

PowerMan1 — Mon, 27 Mar 2023 08:58:12 GMT

I have two variables and want to sum in one Measure.

VAR Filter1 = { 196, 176, 137, 167, 171, 141, 160, 161 }
VAR Filter2 = { 145, 121 }
VAR FIlter3 = { 2065, 178, 138, 189, 148, 149, 190, 164, 2578, 2778, 2878, 194, 169 }

VAR Income =
CALCULATE (
[Income],
DATESMTD ( 'Date'[Date] ),
FILTER (
OrganizationDepartment_LookUP,
NOT ( OrganizationDepartment_LookUP[CODE] ) IN Filter1 &&
NOT ( OrganizationDepartment_LookUP[CODE] ) IN Filter2 &&
NOT ( OrganizationDepartment_LookUP[CODE] ) IN Filter3 ) )

VAR HoureTarget =
CALCULATE (
CALCULATE (
SUMX (
DoctorTarget,
DoctorTarget[TARGET] * CALCULATE ( [RealTime], DATESMTD ( 'Date'[Date] ) ) ),
FILTER (
OrganizationDepartment_LookUP,
NOT ( OrganizationDepartment_LookUP[CODE] ) IN Filter1 &&
NOT ( OrganizationDepartment_LookUP[CODE] ) IN Filter2 &&
NOT ( OrganizationDepartment_LookUP[CODE] ) IN Filter3)),
TREATAS (
SUMMARIZE ( 'Date', 'Date'[Year], 'Date'[Month Number] ),
DoctorTarget[YEAR],
DoctorTarget[MONTH] ) )

RETURN CALC4 = IF ( HoureTarget = BLANK(), Income, HoureTarget )

My result is sum, but it is not correct. this tree values which is "result true" does not add at the department level:

Re: Sum In One Measure

v-jingzhang — Wed, 29 Mar 2023 02:38:23 GMT

Hi PowerMan1

Not sure if I understand your expected result correctly. Do you want to add up the total of all sub values and show it on the subtotal row? If so, you can try the following measure:

measure2 = SUMX ( VALUES ( 'Table'[Code] ), [your original measure] )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

topic Sum In One Measure in DAX Commands and Tips

Sum In One Measure

Re: Sum In One Measure