topic Re: Getting Error: calculation error in measure in DAX Commands and Tips

Getting Error: calculation error in measure

TahniatMansoor — Mon, 18 Jul 2022 16:28:59 GMT

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_SUMMARY (2)'[CAT] <> {40,50,52,53})

I am trying to do a DIVIDE on all of the rows in table scorecard omitting rows where CAT where is 40, 50, 52, 53. I am getting an error table of mutiple values was supplied where a single value was expected. What am I doing wrong ?

Re: Getting Error: calculation error in measure

technolog — Mon, 18 Jul 2022 17:23:25 GMT

Hi! You must use CALCULATE twice inside DIVIDE:

CI_DIST + DIVIDE( CALCULATE(....), CALCULATE(....) )

Re: Getting Error: calculation error in measure

tamerj1 — Mon, 18 Jul 2022 20:19:14 GMT

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