=Calculate(Sum([Column1]),[Column2]=@[Column2])

[ndsutherland]

I presume I have a fundamental misunderstanding, but how would I imitate the excel sumif function using [@[Column]] criteria

 

[Kamolga]

=SUMIF([Column1];[@Column2];[Column3])

with column 1 as range, cell in same line column 2 as criteria and column 3 as sum range

 

[SpillerBD]

=SUMIF([Column1],[@Column1],[Column2])

 

[ndsutherland]

Sorry, I know how to use sumif. I want to know what this looks like in DAX

 

[scottsen]

Spiller and Kamolga didn't realize they were in the PowerBI forum. That happens

OP, for that style you will need to add a FILTER().

It's going to depend on exactly what you are trying to do, but something like:
=CALCULATE(SUM(Facts[foo]), FILTER(SomeTable, SomeTable[Col1] = Facts[Col]))

 

[ndsutherland]

Thanks. Found what I need here: WMP Blog » Favorite Quick & Easy DAX: Calculate Percent of Total Scenario

ALLEXCEPT() for the filter