distinct Count of tour request numbers

[DanduMani104]

hello team,
I have Append-QMR table in power bi. i have TOUR_REQUEST_NO and WEEK_NO and INQUIRY_DATE_KEY and TERMINATION_YEAR columns in that table. the INQUIRY_DATE_KEY is related with DATE_KEY  column in M_INQ_DATE_D date table.In this table I have full date. I want to count the distinctcount of TOUR_REQUEST_NO created in in this week by taking refence INQUIRY_DATE_KEY .

Im getting more trouble with the dax function
i have used 

DistinctCount_ThisWeek =

CALCULATE(

    DISTINCTCOUNT('Append-QMR'[TOUR_REQUEST_NO]),

    FILTER(

        'Append-QMR',

        'Append-QMR'[INQUIRY_DATE_KEY] >= FIRSTDATE(M_INQ_DATE_D[FULL_DATE].[Date]) &&

        'Append-QMR'[INQUIRY_DATE_KEY] <= LASTDATE(M_INQ_DATE_D[FULL_DATE].[Date])

    )

)fucction

[nareshr89]

You dont need weekcolumn in specific as this information is picked up based on the WEEKNUM DAX function. Just the date column is required. 

[DanduMani104]

the error is 

[nareshr89]

Try this DistinctCount_ThisWeek =
CALCULATE(
DISTINCTCOUNT('Append-QMR'[TOUR_REQUEST_NO]),WEEKNUM('Append-QMR'[INQUIRY_DATE_KEY].[Date])=WEEKNUM(NOW())

           )

 If it still doesn't work share a sample PBIX file.

[DanduMani104]

[DanduMani104]

This is my model

[nareshr89]

Try this DistinctCount_ThisWeek =
CALCULATE(
DISTINCTCOUNT('Append-QMR'[TOUR_REQUEST_NO]),
FILTER(

    WEEKNUM(M_INQ_DATE_D[FULL_DATE].[Date])=WEEKNUM(NOW())

           )

 )

[DanduMani104]

I tried this..one but in Date Table ..We do not have week column right?