How to do dynamic sum Ifs in power bi

[o59393]

Hi all

How can I do with dax a dynamic sumifs like this:

Basically, sum if the SKU and plant are the same.

pbix: https://1drv.ms/u/s!ApgeWwGTKtFdhwWaPpXv_NVUuIFM?e=1wDmQ4

Thanks!

[harshnathani]

Hi @o59393 ,

Not very clear of your requirement.

YOu can just use SUM

SUMSKUPLANT= SUM(Table_query__51[%])

or incase you want to group by SKU

SUMSKU = CALCULATE(SUM(Table_query__51[%]), ALLEXCEPT(Table_query__51,Table_query__51[SKU]))

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[edhans · Accepted solution]

You don't need SUMIFS() in Power BI. Just use SUM(). It will sum based on the filter context, so if you add the SKU and Plant to a matrix visual, then use the following measure, it will sum only where it equals the SKU and Plant.

Measure = SUM(Table_query__51[%])

[amitchandak]

@o59393 , You need to tell exact need.

Sumx(filter(Table[H] ="ABC"),Table[G])