Forum Discussion

Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago
Solved

Writing a more efficient DAX measure

Hi,   I recently wrote a DAX measure based on some help I got on this forum. However I now see that these measures are very consuming in terms of memory and slow my report down way too much. I have...
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    Mr. Matt , 

     

     

    Try this one surely it will help you , if not let me know i will help u 

     

     

    Weighted Question = var team_Manger = 'Question Answer'[Team Member]

    var Total_Hours = CALCULATE(SUM('Question Answer'[Number of Hours]),FILTER(ALL('Question Answer'),'Question Answer'[Team Member]=team_Manger))

    return ('Question Answer'[Number of Hours]/Total_Hours) * 'Question Answer'[Question 1 Value]

     

    Create as Calculated Column 

    Cal ColumnOutput

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Hi matt, 

 

 

Create one Calculated Column on your Table and apply this below logic 

 

 

Weighted Question = var team_Manger = 'Question Answer'[Team Member]

var Total_Hours = CALCULATE(SUM('Question Answer'[Number of Hours]),FILTER(ALL('Question Answer'),'Question Answer'[Team Member]=team_Manger))

return ('Question Answer'[Number of Hours]/Total_Hours) * 'Question Answer'[Question 1 Value]

 

Note : 

Replace Table_Name and Column based on your Requierment.

 

 

Let me know if not solve your problem , Cheers