Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Solved! Go to 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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHey,
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
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.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |