Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi guys,
I want to do a measure that is filtered by only one filter, so I want to exsclude all the others.
I have tried using ALL() but there are many, many, many tables so I'm looking for a function faster.
Thank you all 😁
Solved! Go to Solution.
@giuliapiazza94 does ALLEXCEPT helps your scenario
ALLEXCEPT(<tbl>,<tbl[onlyColumnToKeepFilter]>)
Best way is to remove all filters and then add back the specifc column you need.
Like:
Example =
CALCULATE(
[Your Measure]
REMOVEFILTERS(),
VALUES('Product'[Brand])
)
best solution ever!!!
Thankyou.
try ALLSELECTED FUNCTION
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
@giuliapiazza94 does ALLEXCEPT helps your scenario
ALLEXCEPT(<tbl>,<tbl[onlyColumnToKeepFilter]>)
I've tried but it doesn't work
The total should be 293795,54, not 78,18
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |