Make total as the sum of the rows

[afbraga66]

Hey,

I am having an issue trying to make the target only show values when the real has values. For the rows it is working, but on the total it is displaying the total value of the target despite if the real had value or not. I expected it to show 3,05 instead of 11,15.

This is the measure that I have:

Production Defect Target (SUn) =
IF(NOT ISBLANK([Production Defect]),
CALCULATE(
SWITCH (
SELECTEDVALUE ( h_Units[Value] ),
0, BLANK(),
1, SUM(F_TARGETS[# Defect (m3)]),
2, BLANK(),
3, BLANK()
),
ALL(F_PRODUCTION_DEFECT),
F_TARGETS[Source] = "Prod. Defects"
))

Any idea how can I fix this? Thank you.

Best regards,

André

[afbraga66]

Hey,@tamerj1

That work's! thank you very much!

[tamerj1 · Accepted solution]

Hi @afbraga66 

please try

Production Defect Target (SUn) =
SUMX (
VALUES ( 'Table'[Defect] ),
IF (
NOT ISBLANK ( [Production Defect] ),
CALCULATE (
IF ( SELECTEDVALUE ( h_Units[Value] ) = 1, SUM ( F_TARGETS[# Defect (m3)] ) ),
ALL ( F_PRODUCTION_DEFECT ),
F_TARGETS[Source] = "Prod. Defects"
)
)
)