Argument '5' in SUMMARIZE function is required

JustinDoh1 — Mon, 30 Aug 2021 23:41:53 GMT

I am trying to figure out what I am missing here:

I am getting error message saying 'Argument '5' in SUMMARIZE function is required'

Refused_Consented_ForRefusedStep2 =

VAR __ClientID = MAX(Table1[ClientID])

VAR __Table12 = FILTER(ALL(Table1),[ClientID]=__ClientID && [Step]=2 )

VAR __Step2Consent =

SUMMARIZE(

FILTER( __Table12,

[Consent] = "Consented" ),

[Consent],

"__ImmunizationDate",SUM(Table1[ImmunizationDate]),

)

VAR __Step2Refuse =

SUMMARIZE(

FILTER( __Table12,

[Consent] = "Refused" ),

[Consent],

"__ConsentDate",SUM(Table1[ConsentDate])

)

VAR __Step2ConsentDate = MAXX(__Step2Consent,[__ImmunizationDate])

VAR __Step2RefuseDate = MAXX(__Step2Refuse,[__ConsentDate] )

VAR __Step2ConsentReturn = MAXX(FILTER(__Step2Consent,[__ImmunizationDate] = __Step2ConsentDate), [Consent])

VAR __Step2RefuseReturn = MAXX(FILTER(__Step2Refuse,[__ConsentDate] = __Step2RefuseDate), [Consent])

Return __Step2RefuseDate

Thank you

Re: Argument '5' in SUMMARIZE function is required

Greg_Deckler — Tue, 31 Aug 2021 00:01:28 GMT

JustinDoh1 In your first SUMMARIZE, get rid of the extra comma. Also, you don't really need SUMMARIZE if you are filtering down to just one value but that's not why you are getting the error.

"__ImmunizationDate",SUM(Table1[ImmunizationDate]),

Re: Argument '5' in SUMMARIZE function is required

JustinDoh1 — Tue, 31 Aug 2021 00:27:19 GMT

Greg_Deckler Thank you Greg again!

topic Re: Argument '5' in SUMMARIZE function is required in DAX Commands and Tips

Argument '5' in SUMMARIZE function is required

Re: Argument '5' in SUMMARIZE function is required

Re: Argument '5' in SUMMARIZE function is required