average of a result

4 Topics

Cumulative total days active product
Hi all, Been struggeling with this challenge: Per month, I need to see the average of active days per product. Example, 1 product gets active on 1-jan-2024, and gets deactivated on 1-oct-2024. So on 10-jan-2024 the average of active days = 10, on 30-9-2024, the average of active days = 274. On 1-10-2024 its NULL for this product. This is for 1 product, but it needs to aggregate for all products active on that day. For the convenience I mad a fact table (fact_ActiveProducts) with 1 row per product per active day. fact_ActiveProducts, columns: ProductID ,DateID (related with Calendar table) ,BeginDate (date format) ,EndDate (dateformat) (can be empty when still active). ,NumberOfActiveDays (1, a hard number 1 on each row to easy SUM the column). Anybody got suggestions? The usual ways to calculate a rolling sum of cumulative total still counts the days of products after they where deactivated. And after the date that they are deactivated, they shouldn't be counted anymore for those dates. If I get the total count of days per row, I can divide it by a distinctcount of products active on that day. The next step is to create an average by month, or get the value of the maxdate for the selected month.
Solved
Victornld2
1 year ago Place DAX Commands and Tips
771Views
0likes
3Comments
Average answer time for chat messages
Hi, i want to find average answer time for a spesific group. Receivers may be change, i should examine all conversations seperately. Table is like that: sender_id receiver_id date-hour spesific_group 2 1 01.01.2022 09:00 No 1 2 01.01.2022 09.10 Yes 1 3 02.01.2022 10:00 Yes 3 1 02.01.2022 13.00 No 1 3 02.01.2022 13.30 Yes 5 6 02.02.2022 15.00 Yes 6 5 02.02.2022 15.30 No 5 6 02.02.2022 15.40 Yes for ex, sender 1's average answer time is 10 minutes from the conversation with 2 and 30 minutes from the conversation with 3. It means that average answer time for 1 is 20 minutes. And for number 5, average time is 10 minutes. I hope I have been able to explain, thank you If it's too complicated I'm open for another approximate solutions
Solved
selinozdemirpbi
3 years ago Place DAX Commands and Tips
837Views
0likes
1Comment
calculate average percenrage
im trying to calculate the Average achievment percentage by all sales agent. i have created the achievemnt percentage with a measure: calculate(sum(achievmenet)/sum(monthly target)) and i need to get the average achievment for all agents each month for each channel excluding any agent wih position (retail sales supervisor) . in this case the average achievemnt % should be calculated for all the 9 agents with position (retail sales agent) for the selected channel 'Mahboula' and month =' december2022'
lawadaa
3 years ago Place DAX Commands and Tips
808Views
0likes
0Comments
Average of a calculated measure
Hello everyone, I am trying to calculate the average of all services below 100%. Each month I have those services on the dashboard as shown below. Is there a way to calculate the average and place it on a card. Appreciate you help.
kasfour
3 years ago Place DAX Commands and Tips
1.5KViews
0likes
8Comments