Forum Discussion

rgu101's avatar
rgu101
Icon for Helper I rankHelper I
3 years ago

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

Result based on the data you provided not the screenshot from the live data. 

  • rgu101's avatar
    rgu101
    Icon for Helper I rankHelper I
    3 years ago
     JanuaryFebruaryMarchApril
    (+)Q1    
    Location1100%  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.