SUMIF in Power BI

[tejapowerbi]

[FONT=&quot]How to use =SUMIFS for below table in power bi.[/FONT]
[FONT=&quot]=SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID)[/FONT]
[FONT=&quot] [/FONT]
[TABLE="width: 924"]
<tbody style="box-sizing: inherit;">[TR]
[TD]Prior Months
[/TD]
[TD]Region
[/TD]
[TD]Sale Region
[/TD]
[TD]UI
[/TD]
[TD]PID
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Europe
[/TD]
[TD]Europe
[/TD]
[TD]ABC
[/TD]
[TD]ABC
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]Europe
[/TD]
[TD]Europe
[/TD]
[TD]XYZ
[/TD]
[TD]XYZ
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]Europe
[/TD]
[TD]Europe
[/TD]
[TD]OPQ
[/TD]
[TD]OPQ
[/TD]
[/TR]
[TR]
[TD]2.5
[/TD]
[TD]Americas
[/TD]
[TD]Americas
[/TD]
[TD]LKM
[/TD]
[TD]LKM
[/TD]
[/TR]
[TR]
[TD]2.5
[/TD]
[TD]Americas
[/TD]
[TD]Americas
[/TD]
[TD]PKR
[/TD]
[TD]PKR
[/TD]
[/TR]
[TR]
[TD]2.5
[/TD]
[TD]Americas
[/TD]
[TD]Americas
[/TD]
[TD]JKL
[/TD]
[TD]JKL
[/TD]
[/TR]
[TR]
[TD]2.5
[/TD]
[TD]Americas
[/TD]
[TD]Americas
[/TD]
[TD]GUJ
[/TD]
[TD]GUJ
[/TD]
[/TR]
[TR]
[TD]2.5
[/TD]
[TD]Americas
[/TD]
[TD]Americas
[/TD]
[TD]RAJ
[/TD]
[TD]RAJ
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Matty]

Hi,

Suggest looking at SUM wrapped inside CALCULATE.

This link may help:

https://powerpivotpro.com/2009/12/powerpivot-dax-calculate-is-a-supercharged-sumif/

Cheers,

Matty