Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
User | Count |
---|---|
17 | |
17 | |
14 | |
13 | |
13 |
User | Count |
---|---|
17 | |
14 | |
14 | |
10 | |
8 |