Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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
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
thank yo so much Yuliana.
You can also use a SUMX along these lines
SUMX( FILTER( Table1, <Conditions Here> ), Table1[Column to Sum] )
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |