Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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 |
Sum of Criteria = SUMX(FILTER('Table', 'Table'[City] = "BEKASI" && 'Table'[Class] = "B" && 'Table'[Gender] = "P"), 'Table'[Value])
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 7 | |
| 7 | |
| 6 |