Sumifs Calculation

[Anonymous]

Hi frds,

I have doubt in Sumifs calculation in power Bi.

Please help me.

Thanks,

Kali

[amitchandak]

@Anonymous 

You can try a new measure

Calculate(sum(Table[spare Capacity],allexcept(Table[Group])

refer:https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/

[Anonymous]

Hi @amitchandak  Thank you,

thanks for your help,

in case i have summing sumifs in Group,Product,year
please help me.

Thanks,

Kali

[amitchandak · Accepted solution]

@Anonymous ,

In case you need a new column

sumx(filter(Table,Table[Group] = earlier(Table[Group]) && Table[Product] = earlier(Table[Product])),Table[Spare capacity])
Or
sumx(filter(Table,Table[Group] = earlier(Table[Group]) && Table[Product] = earlier(Table[Product])
				 && Table[year] = earlier(Table[year]) ),Table[Spare capacity])