Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
87 | |
77 | |
52 | |
37 | |
21 |