Forum Discussion
Calculated Column Divide by filtered SUMX
Dear All, I need some help regarding a calculated column. My code doesn't working but I don't know how can I fix it. DIVIDE(
Table1[Duration],
CALCULATE(
SUMX(Table1, Table1[...
amitchandak
Super User
Super UserAnonymous , Try a measure like
DIVIDE(
Sum(Table1[Duration]),
CALCULATE(
SUMX(Table1, Table1[Duration]),
Table1[CompanyName]="Comp_1",
Table1[CompanyName]="Comp_2",
Table1[CompanyName]="Comp_3",
Table1[CompanyName]="Comp_4"
)
)
or
DIVIDE(
Sum(Table1[Duration]),
CALCULATE(
SUMX(Filter( Table1,Table1[CompanyName] in {"Comp_1","Comp_2","Comp_3","Comp_4"}) Table1[Duration])
) )