Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |