cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jayfemi
Helper I
Helper I

SUMIF Equivalent in DAX

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")  

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft
Microsoft

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")

r1.PNG

Here is the sample pbix file for your reference. Smiley Happy

 

Regards

View solution in original post

8 REPLIES 8
v-ljerr-msft
Microsoft
Microsoft

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")

r1.PNG

Here is the sample pbix file for your reference. Smiley Happy

 

Regards

MFelix
Super User
Super User

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

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
hemantsingh
Helper V
Helper V

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

Hi @hemantsingh 

 

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

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. Smiley Happy

 

Regards

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors