Forum Discussion
Jayfemi
Helper I
Helper ISUMIF 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 =...
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
MFelix
Super User
Super UserHi 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
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