Sumif Power bi

Question

Hello - Is it possible to do the same in power bi? This is done in excel 365.&nbsp;Thank you,&nbsp;&nbsp;

greg_deckler · Answer

MansoorSadatNew&nbsp;You can use SUMX(FILTER(...),...) or CALCULTE(SUM(...), FILTER(...)).&nbsp;Excel to DAX Translation - Microsoft Power BI Community

mansoorsadatnew · Answer

Greg_Deckler&nbsp;Thanks Greg! But I could not really follow how to presisely apply&nbsp;SUMX(FILTER(...),...) OR&nbsp;CALCULTE(SUM(...), FILTER(...)). Would you mind trying to add name of columns in thse formulas please? Thanks in advance.

greg_deckler · Answer

MansoorSadatNew&nbsp;I don't really understand your SUMIF logic, can you explain what it is doing?

anonymous · Answer

Greg_Deckler&nbsp;- Sure Greg! So, I have been working on a project that I want to count the number of WOs per month (The 2nd column in my screen shot) and Average cost/WO (3rd colum). The problem is that there are WOs in my data dump, which occures 2 time or more (i.e +100 and -$100, which results $0. Thes WOs increase the count of WO# resulting in decreased Avg cost/WO.&nbsp;Fore example, there are 10 WOs for a total of $300, so it return the Avg cost/WO = $30 ($300/10). But amongst the 10 WOs, there are 4 identical WOs which totals $0, which results in incorrect Avg cost/WO. I don't want to include WOs with $0 cost in my Matrix table. Then, the correct Average cost/WO would be $50 ($300/6 WOs) instead of $30 ($300/10 WOs). I didn't want to include such details in an attempt to reduce confustion n the first post, but here is the mistry I am struggling to solve for quite a while.&nbsp;Thanks in advance for any advice you may have.&nbsp;&nbsp;

Forum Discussion

Sumif Power bi

4 Replies

Related content

SumIf

Sumif in Power BI?

SUMIF equivalent DAX in Power BI

Sumifs in power query

SUMIF IN POWER BI