Forum Discussion
Solved
[DAX] Create Table with using group sum
Hello I want to Create DAX Table Table1 ModuleID StatusScore A1 0 A1 0 A1 1 A2 0 A2 0 A2 0 A3 1 A3 10 A3 1 A4 0 A4 1 A4 0 A5 0 A5 0...
ChoiJunghoon , Try like
Create Table=
VAR x0=SUMMARIZE(filter(Table1, not(Table1[ModuleID] in values(Table2[ModuleID])) ,Table1[ModuleID],"SUM_",SUM(Table1[StatusScore]))
VAR x1=FILTER(x0,[SUM_]>0)
RETURN
x1
ChoiJunghoon , Try like
Create Table=
VAR x0=SUMMARIZE(filter(Table1, not(Table1[ModuleID] in values(Table2[ModuleID])) ,Table1[ModuleID],"SUM_",SUM(Table1[StatusScore]))
VAR x1=FILTER(x0,[SUM_]>0)
RETURN
x1
Thank you!! Thank you!!