Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I column for Week Start date with the below dax formula:
what are the additional measures/dax formulas needed for me to get the total count per week.
Thanks.
Solved! Go to Solution.
Hi @gheecalipes25 ,
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
the formula worked. its good now. thank you
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:
Hi @gheecalipes25 ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |