Help with SUMIFS function

[bouyazbekj]

Hey guys, is there an alternative function for SUMIFS in Power BI? 

Here is my formula and 2 tables in excel. I'm trying to calculate something similar in Power BI

AP Table

A	B	C	D
18999	0	0	111500
20200	0	0	477
20200	0	0	331.12
20200	0	0	63.88
20200	0	0	270
20200	0	0	99.83
52120	20	40	137.7
18999	0	0	20500
14050	0	0	26485

Summary table

A	B	C	D	E	F	G	H	I
red	10	10	-	6,861,730		6,861,730		>50000
green	10	20	-	6,861,730		6,861,730		>50000

Formula

=SUMIFS(AP!D: D,AP!B:B,Summary!B1,AP!C:C,Summary!C1,AP!A:A,Summary!I1)

[v-yuta-msft]

@bouyazbekj,

Not very understand what does the excel formula mean? Could you share some logic of how to generate the summary table for further analysis?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.