Forum Discussion
How can I make this more efficient?
Hello, As the title states, I'm asking for advice on how I can make this DAX code more efficient. I have limited coding experience, let alone with DAX. Thank you in advance 🙂 ChiefsMonthlyP...
Result based on the data you provided not the screenshot from the live data.
| January | February | March | April | |
| (+)Q1 | ||||
| Location1 | 100% | 0% | ||
| Location2 | 0% |
When collapsed, it should return the monthly positive percent across the whole enterprise for that question and not just an average based on the data currently in the matrix.