Forum Discussion

su1337's avatar
su1337
Regular Visitor
8 years ago

DAX Script for TOTAL and CONCAT

I need help writing a DAX script in PowerBI to take care of the following problems:   1. I need a TOTAL column that will sum the number of 'Runs' for each 'Group'. --> TOTAL for group A would ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi su1337,

 

Alternatively, you can new a calculated table.

Table5 =
SUMMARIZE (
    table4,
    table4[Group],
    table4[Project],
    "Type", CONCATENATEX ( table4, table4[Type], "," ),
    "Runs", SUM ( table4[Runs] )
)

 

Best regards,

Yuliana Gu