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]

Prior Months	Region	Sale Region	UI	PID
	Europe	Europe	ABC	ABC
12	Europe	Europe	XYZ	XYZ
12	Europe	Europe	OPQ	OPQ
2.5	Americas	Americas	LKM	LKM
2.5	Americas	Americas	PKR	PKR
2.5	Americas	Americas	JKL	JKL
2.5	Americas	Americas	GUJ	GUJ
2.5	Americas	Americas	RAJ	RAJ

<tbody style="box-sizing: inherit;">
</tbody>

 

[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