How to use =SUMIFS for below table in power bi.
=SUMIFS(PRIOR MONTHS,REGION,SALES REGION,UI,PID)
Go to Solution.
You can create a measure similar to below:
SUM ( Table[PriorMonths] ),
ALLSELECTED ( Table ),
SELECTEDVALUE ( Table[Region] ) = "Europe"
&& SELECTEDVALUE ( Table[SaleRegion] ) = "Europe"
&& SELECTEDVALUE ( Table[UI] ) = "ABC"
&& SELECTEDVALUE ( Table[PID] ) = "ABC"
View solution in original post
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.
Proud to be a Datanaut!
You can also use a SUMX along these lines
Table1[Column to Sum]
thank yo so much Yuliana.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!