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] ) ) )
)

     

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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] ) ) )
)