Hello Everyone,
I am trying to find a dax function for Sumif that is being done in excel. See the attached screenshot.
If the columns M, L and I matches then i need to create a column that sums Column P.
Don't see the screen shot but SUMIF in DAX is generally one of these forms:
SUMX(FILTER('Table',[Column]="Something"),[Value])
or
CALCULATE(SUM([Value]),[Column]="Something")
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Don't see the screen shot but SUMIF in DAX is generally one of these forms:
SUMX(FILTER('Table',[Column]="Something"),[Value])
or
CALCULATE(SUM([Value]),[Column]="Something")
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Adding the screenshot. Thank you for your response. I tried sum if equivalent dax but i guess i am not using it correctly as the 3 values for P column are not adding up in column R
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
