Make total as the sum of the rows
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é
