Forum Discussion
Sumif Power bi
Community ChampionMansoorSadatNew You can use SUMX(FILTER(...),...) or CALCULTE(SUM(...), FILTER(...)). Excel to DAX Translation - Microsoft Power BI Community
Greg_Deckler Thanks Greg! But I could not really follow how to presisely apply SUMX(FILTER(...),...) OR CALCULTE(SUM(...), FILTER(...)). Would you mind trying to add name of columns in thse formulas please? Thanks in advance.
- Greg_Deckler
MansoorSadatNew I don't really understand your SUMIF logic, can you explain what it is doing?
Greg_Deckler - 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.
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.
Thanks in advance for any advice you may have.
