ALL Function to exclude a slider that contains dates

Question

Hello All&nbsp;I would like to create a matrix in Power BI that includes specific columns. However, I want one particular column to remain unaffected by external filters. To achieve this, I have used the following formula:CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; COUNT('Table1'[On Time]),&nbsp; &nbsp; &nbsp; &nbsp; ALL('Table1'[Date])&nbsp; &nbsp; )Despite using this formula, I've noticed that when I select a date in the slicer, the filter is still being applied to the column. It's worth noting that I tested the formula with countries instead of dates, and it worked as intended.&nbsp;&nbsp;Hope anyone can help me!Edit: I just noticed that the mesure work when I use in the slicer the date as it is but not when I use Date Hierarchy. Any idea why?&nbsp;Thanks&nbsp;&nbsp;🙂&nbsp;

some_bih · Answer

Hi&nbsp;Juliet1&nbsp;implmeent function ALLEXCEPT depending on your need. Link below and watch video on youtube from same linkhttps://dax.guide/allexcept/&nbsp;. I hope this help&nbsp;

Forum Discussion

ALL Function to exclude a slider that contains dates

1 Reply

Related content

Query contains unsupported function. Function name: Resource.Access

Refresh with a column containing a custom function

Contain Word

contains function

Exclude blanks when using the GENERATESERIES function