how to get the count in a week format

[Anonymous]

Hi,

I column for Week Start date with the below dax formula:

WeekStartDate = 'ECM Data'[Date Created] - WEEKDAY('ECM Data'[Date Created], 2) + 1

but then we i get the total count of tickets, it is not getting the count per week. below is the result i am getting:

what are the additional measures/dax formulas needed for  me to get the total count per week.

Thanks.

[Anonymous]

the formula worked. its good now. thank you

[Anonymous]

i am still getting the same result. i am not sure if the weekstartdate formula is the problem. Here's how icreated the weekstart date column:

WeekStartDate = 'ECM Data'[Date Created] - WEEKDAY('ECM Data'[Date Created], 2) + 1

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a measure as below to get the count of tickets per week:

Count of tickets =
VAR _tab =
    SUMMARIZE (
        'ECM Data',
        'ECM Data'[WeekStartDate],
        "@count",
            CALCULATE (
                DISTINCTCOUNT ( 'ECM Data'[Ticket Number] ),
                FILTER (
                    'ECM Data',
                    'ECM Data'[WeekStartDate] = EARLIER ( 'ECM Data'[WeekStartDate] )
                )
            )
    )
RETURN
    SUMX ( _tab, [@count] )

Or you don't need to create any measure, just create a table visual with the field [WeekStartDate] and put the field [Ticket] with the aggregation function: Count(Distinct) just as below screenshot:

You can find all above information in the attachment.

Best Regards