Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello Guys!
I am trying to write a Measure that Sums up one Value "Value Transaction" while using 3 Filters.
SumValue =
calculate(sum('COEP'[Value TranCurr]),FILTER('COEP','COEP'[Business Transaction]="COIN"
&& COEP[Name] <> "*CUT*OF*" || COEP[Name] <> "OOS*WBS"))
Do you guys see why this is not working? so my logic would be that the first (blue) condition shall always be true and than one of the red conditions would also have to be true for the value to be summed up. sadly I always get a 0 as total.
DATA:
Project ID | Business Transaktion | Value TranCurr | Name | SumValue |
1 | COIN | 0 | CUT OFF 01 2018 | 0 |
2 | COIN | 0 | CUT OFF 03 2017 | 0 |
3 | COIN | 2250 | Project cost | 2250 |
4 | COIN | 1874 | HE17RF27594.1 | 1874 |
4124 (TOTAL) | 0 (TOTAL) |
Solved! Go to Solution.
Try this measure. Notice that I filtered COEP[Name] instead of the entire table. It's best to use column filters instead of table filters when possible.
SumValue =
CALCULATE (
SUM ( COEP[Value TranCurr] ),
COEP[Business Transaction] = "COIN",
FILTER (
ALL ( COEP[Name] ),
NOT CONTAINSSTRING ( COEP[Name], "*CUT*OF*" )
|| NOT CONTAINSSTRING ( COEP[Name], "OOS*WBS" )
)
)
Proud to be a Super User!
Try this measure. Notice that I filtered COEP[Name] instead of the entire table. It's best to use column filters instead of table filters when possible.
SumValue =
CALCULATE (
SUM ( COEP[Value TranCurr] ),
COEP[Business Transaction] = "COIN",
FILTER (
ALL ( COEP[Name] ),
NOT CONTAINSSTRING ( COEP[Name], "*CUT*OF*" )
|| NOT CONTAINSSTRING ( COEP[Name], "OOS*WBS" )
)
)
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
61 | |
46 | |
45 |