[DAX]ALLSELECTED vs. ALL

Sometimes we would struggle about whether to use ALL or ALLSELECTED. In this article, I will introduce some tips and scenarios to help decide when to use.

ALLSELECTED()

ALLSELECTED(<tableName> or <columnName>)

  • ALLSELECTED removes/ignores all filters but takes into account the overarching context in the report page.
  • For example, most of the time we will have the “Date Slicer” on our reporting page, and we want to show the reports based on “Date Slicer”. Therefore, we…