Forum Discussion
SUMIFS function in Power BI
Hi, I am stuck on how I can apply the following SUMIFS formula into Power BI =E2/SUMIFS(E:E,A:A,A2,B:B,B2)*100 Re-worked with column names (=Cost 2020/21 - Plan/SUMIFS(Cost 2020/21 - Plan,Gr...
AllisonKennedy
Community Champion
Community ChampionCbishop
Generally speaking, you can achieve something similar to a SUMIFS using
Measure = Table[Cost 2020/21 - Plan] / SUMX(FILTER(ALL(Table), Table[Group] = SELECTEDVALUE{Table[Group]) && Table[Month] = SELECTEDVALUE(Table[Month]) ), Table[Cost 2020/21 - Plan] )
You could also look into using ALLEXCEPT in this case too as an alternative option.
Generally speaking, you can achieve something similar to a SUMIFS using
Measure = Table[Cost 2020/21 - Plan] / SUMX(FILTER(ALL(Table), Table[Group] = SELECTEDVALUE{Table[Group]) && Table[Month] = SELECTEDVALUE(Table[Month]) ), Table[Cost 2020/21 - Plan] )
You could also look into using ALLEXCEPT in this case too as an alternative option.