Forum Discussion
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 | 1 |
| Aman | BEKASI | A | L | 1 |
| Umar | LAMPUNG | B | L | 1 |
| Dwi | YOGYAKARTA | C | P | 1 |
| Sofin | JAKARTA | B | L | 1 |
| Alpian | BEKASI | C | L | 1 |
| Wilhelmina | JAKARTA | B | P | 1 |
| Irma | BEKASI | C | P | 1 |
| Mustika | JAKARTA | B | L | 1 |
| Sarippudin | BEKASI | C | L | 1 |
| Erika | BEKASI | B | P | 1 |
1 Reply
devanshiHelper V
Sum of Criteria = SUMX(FILTER('Table', 'Table'[City] = "BEKASI" && 'Table'[Class] = "B" && 'Table'[Gender] = "P"), 'Table'[Value])