How to get weekrange data

[TriveniN]

Hi,

I created below measures to get count of published listing and this measure will return data like below screenshot.

DLA_Published Listing =

VAR _Date = CALCULATE(MAX(Datecalendar[TheDate]))

RETURN

CALCULATE( COUNT(CYCLE_TIME[Name]),  

     //USERELATIONSHIP(CYCLE_TIME[Listing_Start_Date__c],Datecalendar[TheDate]),

     Cycle_Time[Listing_Start_Date__c] <= _Date && Cycle_Time[Listing_Start_Date__c] <> Blank() &&

     (Cycle_Time[Listing_End_Date__c] = Blank() || Cycle_Time[Listing_End_Date__c] > _Date) &&

     CYCLE_TIME[MIR_Inspection_End_Date__c] <> BLANK() && CYCLE_TIME[MIR_Inspection_End_Date__c] <= _Date &&

     CYCLE_TIME[Make_Ready_Type__c] <> "Disposition" ,

    CYCLE_TIME[Make_Ready_Start_Date__c] <> BLANK() &&

    (Cycle_Time[Yardi_Sign_Date__c] = BLANK() || Cycle_Time[Yardi_Sign_Date__c] > _Date),

FILTER(ACQUIRED_PROPERTY, ACQUIRED_PROPERTY[Unit_Status__c] <> "Eviction" &&

    ACQUIRED_PROPERTY[Name] in {[ASOF_Home_Count]} &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Approved_Applications]}) &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Under_Review_Applications]}) &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Occupied_Homes]}) &&

    NOT(ACQUIRED_PROPERTY[Name] in {[ASOF_Under_Renovation]}) &&

    (ACQUIRED_PROPERTY[Disposition_Date__c] > _Date || ACQUIRED_PROPERTY[Disposition_Date__c] = BLANK()) &&

    (ACQUIRED_PROPERTY[Stabilization_Date__c] <> BLANK() || ACQUIRED_PROPERTY[Stabilization_Date__c] = BLANK())

     && Not (ACQUIRED_PROPERTY[Name]) IN {[Model homes]}) )

Requirment is to get data sum of week data.

Example : 12/18/2022 to 12/24/2022  -- >   For this data range we need to get data 260+255+251+251+253+251+251=1772

but when we use above measure in below report getting 251

Can someone guid me , how we can achive this requirment?

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...