Forum Discussion
CALCULATE(IFERROR(AVERAGE giving error
Hello Community, i am trying to created a calculated column and i am getting below error. Does any one able provide suggestion? Error Message “Too many arguments were passed to the IFERROR function...
You've got all kinds of mismatching parenthesis and commas, but I think this might be closer to what you're after:
IFERROR (
CALCULATE (
AVERAGE ( [Valid Price] ),
FILTER (
'Software Contracts',
[RAW Unique Identifier] = 'Software Contracts'[AUP Pricing Identifier]
),
FILTER (
'Software Contracts',
[RAW Region] = 'Software Contracts'[ AUP SALES] )
),
"no"
)
AlexisOlson
Super User
Super UserYou've got all kinds of mismatching parenthesis and commas, but I think this might be closer to what you're after:
IFERROR (
CALCULATE (
AVERAGE ( [Valid Price] ),
FILTER (
'Software Contracts',
[RAW Unique Identifier] = 'Software Contracts'[AUP Pricing Identifier]
),
FILTER (
'Software Contracts',
[RAW Region] = 'Software Contracts'[ AUP SALES] )
),
"no"
)
thank you so much Alexis.It works perfectly fine for me.