Forum Discussion
Solved
SUMIFS Equivalent to Check for Row Value
Good evening. I'm trying to build a SUMIFS equivalent formula that checks the value of a given row and sums the values in a column that match the values of that row. I wrote the following formu...
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...
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
Ahmedx
Super User
Super Userpls try this
Column =
VAR t1 = [Registry]
VAR t2 = [Type]
VAR _Results = SUMX(FILTER(ALL('Table'),'Table'[Registry]=t1&&'Table'[Type]=t2),[QTY])
RETURN
_Results
Sir, you're a wizard. I wish I could give you more than just a thumbs up.