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

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
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