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(<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…