SUMIF Equivalent in DAX

[Jayfemi]

Hi, 

I am inthe process of moving reports from excel onto power Bi and i am having some problems finding the DAX alternative so some common formulas i use.

For example i am usiing this sum ifs =SUMIFS(Allocated,Month,F$8,Workflow,"Reactive on DRS")  

[v-ljerr-msft · Accepted solution]

Hi @Jayfemi,

---

For example i am usiing this sum ifs =SUMIFS(Allocated,Month,F$8,Workflow,"Reactive on DRS")  

---

Based on my test, the formula below should work in your scenario.

Sum Of Allocated = CALCULATE(SUM(Data[Allocated]),Data[Workflow]="Reactive on DRS")

Here is the sample pbix file for your reference. 

Regards

[Jayfemi]

Thank you very much @v-ljerr-msft @MFelix @TomMartens @hemantsingh

[MFelix]

Hi @Jayfemi,

Just use the CALCULATE function something like this

CALCULATE( SUM(Table[Allocated]), Table[Month]= Calendar[Month], Table[Workflow]="Reactive on DRS")

Don't know you're exact model but it will be sonething like the above where the first argument is the summarization you want the rest are the filter you want to make.

Regards,
MFelix

[TomMartens]

Hey,

basically you can use this pattern

SUMX('your table'
  ,if('yourtable'[columnyousearchin] = "yoursearchvalue" 
    ,calculate(SUM('yourtable'[column you want to sum]))
    ,BLANK()
)

Hope this gets you started

[hemantsingh]

Hi @Jayfemi,

    It would be great if you have shared some sample data or the result you are trying to achieve. I still believe "calculate wrapped in if " would do what you want.

Regards,

Hemant

[Jayfemi]

Hi @hemantsingh 

please see sample data ideally i am trying to recreate the charts on the tab Vital statistics in Bi

[v-ljerr-msft]

Hi @Jayfemi,

---

please see sample data ideally i am trying to recreate the charts on the tab Vital statistics in Bi

---

Where is your sample data? I can't find it anywhere. 

Regards

[Jayfemi]

Hi @v-ljerr-msft 

Please see link below

https://www.dropbox.com/s/eetglnrmcphdhxj/Sample%20Data.xlsm?dl=0