SUMIF in Power BI

[Anonymous]

How to use =SUMIFS for below table in power bi.

=SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID)

Prior Months	Region	Sale Region	UI	PID
0	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

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You can create a measure similar to below:

SumValue =
CALCULATE (
    SUM ( Table[PriorMonths] ),
    FILTER (
        ALLSELECTED ( Table ),
        SELECTEDVALUE ( Table[Region] ) = "Europe"
            && SELECTEDVALUE ( Table[SaleRegion] ) = "Europe"
            && SELECTEDVALUE ( Table[UI] ) = "ABC"
            && SELECTEDVALUE ( Table[PID] ) = "ABC"
    )
)

Best regards,

Yuliana Gu

[Anonymous]

thank yo so much Yuliana.

[AlexisOlson]

You can also use a SUMX along these lines

SUMX(
    FILTER(
        Table1,
        <Conditions Here>
    ),
    Table1[Column to Sum]
)

[Greg_Deckler]

Generally SUMIF means that you are summing based upon some condition. The general replacement for SUM if is to use a CALCULATE with a SUM and a FILTER.