Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi, i am new with power BI and i am wondering how to create a measure using a filter on another measure, but using allexcept. The goal is for example to have all the sports sales except for hockey and basket,
Thank you
Solved! Go to Solution.
Whoops, had my NOT in the wrong spot.
Sales excl 2 = CALCULATE ( SUM ( 'table'[Sales Amount] ), NOT 'table'[Sport] IN {"hockey","basketball"} )
Whoops, had my NOT in the wrong spot.
Sales excl 2 = CALCULATE ( SUM ( 'table'[Sales Amount] ), NOT 'table'[Sport] IN {"hockey","basketball"} )
It works, thanks a lot!
No, that would be this.
Sales 2 = CALCULATE ( SUM ( 'table'[Sales Amount] ), 'table'[Sport] IN {"hockey","basketball"} )
That is not really what ALLEXCEPT is for. To do what you are describing would be along these lines.
Sales excl 2 = CALCULATE ( SUM ( 'table'[Sales Amount] ), 'table'[Sport] NOT IN {"hockey","basketball"} )
When i write, it highlights the word NOT in red saying it's an unexpected expression?
ok, and i guess if i want to create the same type of mesure except this time by filtering the sales for hockey AND basket, i just have to write :
CALCULATE ( SUM ( 'table'[Sales Amount] ), 'table'[Sport] IN {"hockey"}, 'table'[Sport] IN {"basketball"} )
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
81 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |