The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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])
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |