Need Help- Total Goals Scored using DAX

[somya_jain]

I need 

I have input like the above image

and want output like below image using Dax measures

@Anonymous @mim @dax @Meak 

Thanks in advance

[amitchandak · Accepted solution]

@somya_jain , in DAX you have use summarize and union

Try lik

SUMMARIZE(
Union(
selectcolumns(Table, "Team",Table[HomeTeam], "Goal",Table[Home Goal]),
selectcolumns(Table, "Team",Table[awayTeam], "Goal",Table[Away Goal])
),[Team] ,"Goal", sum([Goal]))

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

[nvprasad]

Hi,

You can use the "GroupBY" transformation in the query editor to get this output.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[somya_jain]

Thanks for your help but I was looking for solution using dax