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
Hi GreenKnight1294 .
I am sorry , i just not sure i understan what you have vs what you need.
Please share your table un iseful format ( not screenshot) and desired result. I will try to help
Hey Ritaf1983
It seems I accidentally replied to the main post and not to you directly. Just wanted to let you know.
Thanks.
- Ritaf19833 years ago
Super User
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...