Forum Discussion

Jayfemi's avatar
Jayfemi
Icon for Helper I rankHelper I
9 years ago
Solved

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 =...
Need Help
Show and Tell
Tutorial Requests
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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. :smileyhappy:

     

    Regards

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

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