Divide based on measures

[YcnanPowerBI]

Hello everyone,

I am facing an issue when trying to divide by two measures.  Here are my measures being used, current and expected outcome as well as sample data.  It appears to only be diving by any account that has "1 Week" tickets v all, but haven't been successful when I change any of the DAX below.   Any help, greatly appreciated.

1 Disctinct Accounts = DISTINCTCOUNT(Merge1[Account Number & Name])

1 Sum of Tickets Week 1 = CALCULATE(sum(Merge1[Ticket Details.Tickets]),Merge1[Weeks for Tickets Created] = "1 Week")

1 Tickets per Install = DIVIDE([1 Sum of Tickets Week 1],Merge1[1 Disctinct Accounts])

CURRENT V EXPECTED RESULTS

	February	March	April
Distinct Accounts	2	1	1
1 Sum of Tickets Week 1	8	5	2
1 Tickets per Install - Current	8	5	2
1 Tickets per Install - Expected	4	5	2

SAMPLE DATA

 

Account Number & Name	Ticket Details.Tickets	Weeks for Tickets Created	Project Complete
1	1	1 Week	April
1	1	1 Week	April
1	1	2 Weeks	April
2	1	1 Week	March
2	1	1 Week	March
2	2	2 Weeks	March
2	1	2 Weeks	March
2	1	1 Week	March
2	1	1 Week	March
2	1	1 Week	March
2	1	2 Weeks	March
2	1	2 Weeks	March
2	1	2 Weeks	March
2	1	2 Weeks	March
2	1	3 Weeks	March
3	1	2 Weeks	February
3	1	2 Weeks	February
3	1	1 Week	February
3	2	1 Week	February
3	1	2 Weeks	February
3	1	1 Week	February
3	1	1 Week	February
3	1	1 Week	February
3	1	1 Week	February
3	1	1 Week	February
3	1	2 Weeks	February
3	1	2 Weeks	February
3	1	2 Weeks	February
3	1	2 Weeks	February
3	1	2 Weeks	February
3	1	2 Weeks	February
4	1	2 Weeks	February
4	1	2 Weeks	February
4	1	3 Weeks	February

[PhilipTreacy · Accepted solution]

Hi @YcnanPowerBI 

I've created a file with the data you posted above and I do not have the issue.  It works as you expect - please check my file to see what is different to yours.

Download example PBIX file

Also, are you using dates and/or a date table or are the month names text?  You should use proper dates.

Regards

Phil