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.
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"} )
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |