Forum Discussion
Clearing filter context from key column
Hi Anonymous ,
For the difference between ALL(column) and ALL(table), you can check this blog:
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI.
Then in your scenario, try this:
total = CALCULATE ( [sales_measure], TREATAS ( ALL ( 'fact'[color id] ), 'Dim'[Dim color id] ), ALL ( 'fact'[color id] ) )Here's my test example:
Reference: TREATAS function - DAX | Microsoft Docs
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That is not what I was asking.
The question is how can I clear the filter context in fact table that is coming from one dimension, by using field from a fact table. ALL(fact) is working here but it is clearing as well the rest of filter context from other dimenstions that I would like to keep.
- Icey
Community Support
Hi Anonymous ,
For the difference between ALL(column) and ALL(table), you can check this blog:
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI.
Then in your scenario, try this:
total = CALCULATE ( [sales_measure], TREATAS ( ALL ( 'fact'[color id] ), 'Dim'[Dim color id] ), ALL ( 'fact'[color id] ) )Here's my test example:
Reference: TREATAS function - DAX | Microsoft Docs
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.