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

[Anonymous]

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

[v-robertq-msft]

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.