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

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