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

Am not getting ur expected Answer .

 

if u don't mind can u pls explain me what is in "Weight Question One Value " in Excel 

 

(30/64)*4 + (30/64)*2 

 

How u getting this , 

i think this is u want as a output in DAX.

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

    I am indeed looking for a dax function that gives me the weighted value for the question. So if a person has for example a '2' on a 10 hour project and a '4' on a 20 hour project the dax measure should give me: [(2*(10/30)) + (4*(20/30))]. 30 being the total amount of hours. What do you mean exactly by Team_Manger?

     

    Thanks for helping

     

    Kr,

    Matt

    • Baskar's avatar
      Baskar
      Icon for Resident Rockstar rankResident Rockstar
      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

      • Parihar1980's avatar
        Parihar1980
        Icon for Helper II rankHelper II
        9 years ago

        Please help me to solve this

         

        Select Count(distinct) , Col From Table

        Group by Col 

         

         

        i am not getting result with below expression 

         

         

        =SUMMARIZE(Table , Table[Col] ,

        Countrows(DISTINCT(table[Col])))