Forum Discussion
TahniatMansoor
4 years agoNew Member
Getting Error: calculation error in measure
CI_DIST = CALCULATE (DIVIDE (( (SUM('SCORECARD (2)'[CI_3_AVG])/SUM('RR_SCORECARD_IND_SUMMARY (2)'[CI_3_CAT])) * SUM('SCORECARD(2)'[CI_DIST_YTD]) ) , SUM('SCORECARD (2)'[CS_CURR])),'RR_SCORECARD_IND_S...
- 4 years ago
please use
CI_DIST = CALCULATE ( DIVIDE ( ( ( SUM ( 'SCORECARD (2)'[CI_3_AVG] ) / SUM ( 'RR_SCORECARD_IND_SUMMARY (2)'[CI_3_CAT] ) ) * SUM ( 'SCORECARD(2)'[CI_DIST_YTD] ) ), SUM ( 'SCORECARD (2)'[CS_CURR] ) ), NOT ( 'RR_SCORECARD_IND_SUMMARY (2)'[CAT] IN { 40, 50, 52, 53 } ) )
technolog
4 years agoSuper User
Hi! You must use CALCULATE twice inside DIVIDE:
CI_DIST + DIVIDE( CALCULATE(....), CALCULATE(....) )