Forum Discussion
Divide based on measures
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.
| 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 |
| 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 |
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.
Also, are you using dates and/or a date table or are the month names text? You should use proper dates.
Regards
Phil
1 Reply
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.
Also, are you using dates and/or a date table or are the month names text? You should use proper dates.
Regards
Phil