Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

A complicated SUM based on filtering

Hello,

 

I am new to DAX and would like to know how can I sum the row called "status" for each "Line"

 

 

 

I created a new table with district to get the below 

 

A101

A102

A103 

.

.

.

A110

 

Then I need to have this column which is similar to that

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Create a new table in Power BI and use the formula:

     

    SummaryTbl = SUMMARIZECOLUMNS('YourTbl'[Line_Desc],"Sum of Status",SUM('YourTbl'[Status]))

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Create a new table in Power BI and use the formula:

     

    SummaryTbl = SUMMARIZECOLUMNS('YourTbl'[Line_Desc],"Sum of Status",SUM('YourTbl'[Status]))