Forum Discussion

TahniatMansoor's avatar
TahniatMansoor
New Member
4 years ago
Solved

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...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi TahniatMansoor 

    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 } )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi TahniatMansoor 

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 } )
)