THE PARAMETER IS NOT THE CORRECT TYPE MESSAGE WHILE WORKING WITH VARIABLES

Anonymous — Tue, 19 Oct 2021 06:37:53 GMT

HELP PLEASE IM GETTING THE FOLLOWING MESSAGE THE PARAMETER IS NOT THE CORRECT TYPE IN ALL THE FILTERS FOR THE START WEEK

WHEN I TEST ALL THE VARIABLES SEPARATED THEY WOR BUT TOGETHER IT DOESNT WORK

W10 Q3 =

VAR CWHeadcount = SUM(CurrentHC[CW FTE])

VAR RegularOffersaccepted_extendedoff = (CALCULATE(SUM(OfferReq[True accepted]),FILTER(OfferReq,OfferReq[Employee Type]<>"Intern"),FILTER(OfferReq,OfferReq[Recruiting Instruction]="Regular"||OfferReq[Recruiting Instruction]="US Federal"),FILTER(OfferReq[Start week] = "WK10 Q3FY22"),FILTER(OfferReq,OfferReq[Start Date]<> BLANK())))

VAR Campusaccepted_extended = (CALCULATE(SUM(OfferReq[True accepted]),FILTER(OfferReq,OfferReq[Employee Type]<>"Intern"),FILTER(OfferReq,OfferReq[Recruiting Instruction]="Campus"||OfferReq[Recruiting Instruction]="Recent Graduate Pro"), FILTER(OfferReq[Start week]="WK10 Q3FY22"),FILTER(OfferReq,OfferReq[Start Date] <> BLANK())))

VAR Internaccepted_extendedoff = (CALCULATE(SUM(OfferReq[True accepted]),FILTER(OfferReq,OfferReq[Recruiting Instruction]="Intern"),FILTER(OfferReq[Start week]="WK10 Q3FY22"),FILTER(OfferReq,OfferReq[Start Date]<>BLANK())))

VAR RegularOpenpositionsremainingoff = (CALCULATE(SUM(OpenReqs[True remaining open]),FILTER(OpenReqs,OpenReqs[Requisition Status]="Open"),FILTER(OpenReqs,OpenReqs[Recruiting Instruction]="Regular"||OpenReqs[Recruiting Instruction]="US Federal"||OpenReqs[Recruiting Instruction]="Inbound Sourcing"), FILTER(OpenReqs,OpenReqs[Employee Type] <> "Intern"),FILTER(OpenReqs[Fiscal Week]="WK10 Q3FY22")))

VAR CampusOpenpositionsremainingoff = (CALCULATE(SUM(OpenReqs[True remaining open]),FILTER(OpenReqs,OpenReqs[Requisition Status]="Open"),FILTER(OpenReqs,OpenReqs[Recruiting Instruction]="Campus"||OpenReqs[Recruiting Instruction]="Recent Graduate Pro"), FILTER(OpenReqs,OpenReqs[Employee Type] <> "Intern"),FILTER(OpenReqs[Fiscal Week]="WK10 Q3FY22")))

VAR InternOpenpositionsremainingoff = (CALCULATE(SUM(OpenReqs[True remaining open]),FILTER(OpenReqs,OpenReqs[Requisition Status]="Open"),FILTER(OpenReqs,OpenReqs[Recruiting Instruction]="Intern"||OpenReqs[Recruiting Instruction]="Inbound Sourcing"),FILTER(OpenReqs[Fiscal Week]="WK10 Q3FY22")))

VAR PendingReqsoff = (CALCULATE(SUM(PendingReq[# Openings]),FILTER(PendingReq[Fiscal Week]="WK10 Q3FY22")))

VAR AttbyWeek = (-CurrentHC[Attrition]*CurrentHC[CW Headcount])/52

VAR W10Q3 = CWHeadcount + RegularOffersaccepted_extendedoff + Campusaccepted_extended +Internaccepted_extendedoff+ RegularOpenpositionsremainingoff+CampusOpenpositionsremainingoff+InternOpenpositionsremainingoff+PendingReqsoff+AttbyWeek

RETURN

W10Q3

Re: THE PARAMETER IS NOT THE CORRECT TYPE MESSAGE WHILE WORKING WITH VARIABLES

v-robertq-msft — Mon, 25 Oct 2021 09:13:42 GMT

Hi,

According to your description, I can’t roughly understand what you want to get. Would you like to post some sample data in table form or pbix file(without sensitive data) and your expected result(like the chart you want to get and the correct measure value based on your sample data)?

Thanks very much!

How to Get Your Question Answered Quickly

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: THE PARAMETER IS NOT THE CORRECT TYPE MESSAGE WHILE WORKING WITH VARIABLES in DAX Commands and Tips

THE PARAMETER IS NOT THE CORRECT TYPE MESSAGE WHILE WORKING WITH VARIABLES

Re: THE PARAMETER IS NOT THE CORRECT TYPE MESSAGE WHILE WORKING WITH VARIABLES