Forum Discussion

Matthias93's avatar
Matthias93
Helper 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

Matthias93's avatar
Matthias93
Helper 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
Resident 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
    Helper 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])))

    • srinivaspappu22's avatar
      srinivaspappu22
      New Member
      8 years ago

       

      How to code the below SQL in DAX / Measure / New column in PowerBI Report ? Please help.

      SELECT COL2, COUNT(COL1) FROM TABLE1 Group By COL2

    • srinivaspappu22's avatar
      srinivaspappu22
      New Member
      8 years ago

      Hello Parihar,

       

      Have you got solution for your query ? If so please share the DAX query for the same.

       

      Thanks,

      Srini.