Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

GROUP BY Calculation

Hi, I have this Sprint data                 And I want to calculate de "CALCULATION" column in Power BI             This is the SUM of Points for each Sprint DIVIDED BY CO...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    You may use the following DAX to add a calculated column.

    Column =
DIVIDE (
    SUMX ( RELATEDTABLE ( Table2 ), Table2[Points] ),
    COUNTROWS ( FILTER ( Table1, Table1[SPRINT] = EARLIER ( Table1[SPRINT] ) ) )
)

     

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try a simple

= DIVIDE(SUM([Points]), COUNT([DAYS]))

but before be sure there is a relationship between your tables

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Wouldn't this just give the Total Points / Total Days? 700 / 12