Forum Discussion
SUMIFS Equivalent to Check for Row Value
- 3 years ago
Hi GreenKnight1294 on this table my solution works.
I can't figure out what the problem is.
"Fix" a cell in POWER BI is not possible because of the logic it uses
Rather than working at the cell level, it works at the column level.
It's a game where you release filters and apply filters in a context.
Sumifs in the context of multiple conditions is like I showed calculate ([measure], condition A && condition B etc..)
Unfortunately, I don't know how to help beyond that...
- 3 years ago
pls try this
Column = VAR t1 = [Registry] VAR t2 = [Type] VAR _Results = SUMX(FILTER(ALL('Table'),'Table'[Registry]=t1&&'Table'[Type]=t2),[QTY]) RETURN _Results
Thank you, Rita.
Here's a similar table to what I showed before with the desired result.
The fourth column has the following formula in Excel:
=SUMIFS($A$2:$A$20,$B$2:$B$20,B2,$C$2:$C$20,C2)
| QTY | Registry | Type | SUM |
| 2 | 2290 | 40 | |
| 8 | 2290 | 40 | |
| 10 | 2290 | 40 | |
| 12 | 2291 | 27 | |
| 13 | 2291 | 27 | |
| 2 | 2291 | 27 | |
| 0 | 2291 | 27 | |
| 3 | 2292 | 29 | |
| 8 | 2292 | 29 | |
| 7 | 2292 | 29 | |
| 6 | 2292 | 29 | |
| 5 | 2292 | 29 | |
| 9 | 2290 | 40 | |
| 11 | 2290 | 40 | |
| 16 | 2294 | 43 | |
| 19 | 2294 | 43 | |
| 5 | 2294 | 43 | |
| 3 | 2294 | 43 |
The most important part is that all the numbers that share the same registry value are added together.