Forum Discussion

Alz's avatar
Alz
New Member
3 years ago

Calculate with 3 condition column

hi i have a problem, how to sum the value of 3 column criteria Example: adding value by category City = "BEKASI" Class = "B" Gender= "P" Name City Class Gender Total Friska JAKARTA A P...
devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

Sum of Criteria = SUMX(FILTER('Table', 'Table'[City] = "BEKASI" && 'Table'[Class] = "B" && 'Table'[Gender] = "P"), 'Table'[Value])